PostgreSQL firewall query?

Question

Can I query the database located on "Server 2" and get my data in "Server 1"? This returns the recordset from the remote server to my local one.

PS: Do not cross-query the database on the same server, because I know how to do this with dblink.

Update: .

http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html works like a charm. My bust was that I did not see it in the dblink documentation on the postgresql website.

Answer 1

-, dblink - DbLink PostreSQL

Answer 2

- postgres_fdw: https://www.postgresql.org/docs/9.3/static/postgres-fdw.html