sql - PostgreSQL cross server query? -


Is there any way I can ask the database located on "Server 2" and my data in "Data 1" Can i get He withdraws a set of records from a remote server into my local one.

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

Update: Great ty

Works like a magic My bust was that I did not see it on Dublin Documentation on the PostgreSQL website.

Obviously dblink can be used to query other servers -


Comments