title: Query two different postgres databases stored in different servers
body: <p>I have two <strong>POSTGRES</strong> databases stored in different servers.</p>
  
  <p>The <strong>"Firstdb"</strong> is <strong>version</strong> <strong>9.2</strong> and it is stored in a  LAN server, port <strong>5432</strong>.</p>
  
  <p>The <strong>"Seconddb"</strong> is <strong>version</strong> <strong>10</strong> and it is stored as localhost to my PC, port <strong>5432</strong>.</p>
  
  <p>I have access to both of them through <strong>pgAdmin4</strong> version <strong>2.0</strong>.</p>
  
  <p>I would like to run query between those two databases to compare data.</p>
  
  <p>Any ideas about how this can be done?</p>
  
  <p>Thank you all for your time.</p>