with
   <code class="literal">postgres_fdw</code>. First install the extension:
  </p><pre class="programlisting">
CREATE EXTENSION postgres_fdw;
</pre><p>
   Then create a foreign server using <a class="xref" href="sql-createserver.html" title="CREATE SERVER"><span class="refentrytitle">CREATE SERVER</span></a>.
   In this example we wish to connect to a <span class="productname">PostgreSQL</span> server
   on host <code class="literal">192.83.123.89</code> listening on
   port <code class="literal">5432</