code>.  The database to which the connection is made
   is named <code class="literal">foreign_db</code> on the remote server:

</p><pre class="programlisting">
CREATE SERVER foreign_server
        FOREIGN DATA WRAPPER postgres_fdw
        OPTIONS (host '192.83.123.89', port '5432', dbname 'foreign_db');
</pre><p>
  </p><p>
   A user mapping, defined with <a class="xref" href="sql-createusermapping.html" title="CREATE USER MAPPING"><span class="refentrytitle">CREATE USER MAPPING</span></a>, is
   needed as 