PostgreSQL cross server query?

Question

Is there a way that I might query a database located on "Server 2" and get my data in "Server 1" ? That is return a set of records from a remote server to my local one.

PS: Not cross database query on same server because I know how to do that with dblink.

Update: great ty.

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 didn't see it on the dblink documentation on postgresql website.

possible duplicate of [Possible to perform cross-database queries with postgres?](http://stackoverflow.com/questions/46324/possible-to-perform-cross-database-queries-with-postgres) — Milen A. Radev, May 18 '10 at 13:33

score 15 · Answer 1 · answered Aug 09 '16 at 10:56

15

this is old - these days one would use the postgres_fdw module instead: https://www.postgresql.org/docs/9.3/static/postgres-fdw.html

answered Aug 09 '16 at 10:56

radiospiel

2,450
21
28

1

I suggest the correct answer be changed to this - this is more relevant and correct for today. – Uzair Faisal Mar 29 '17 at 15:24

score 6 · Accepted Answer · answered May 18 '10 at 12:21

6

Apparently dblink can be used to query other servers - Using DbLink to access other PostreSQL Databases and Servers

answered May 18 '10 at 12:21

yozey

432
3
9

PostgreSQL cross server query?

2 Answers2

Related