title: PostgreSQL cross server query?
body: <p>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.</p>
  
  <p>PS: Not cross database query on same server because I know how to do that with dblink.</p>
  
  <p><strong>Update:</strong> great ty. </p>
  
  <p><a href="http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html" rel="noreferrer">http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html</a> works like a charm. My bust was that I didn't see it on the dblink documentation on postgresql website. </p>