well to identify the role that will be used on the remote
   server:

</p><pre class="programlisting">
CREATE USER MAPPING FOR local_user
        SERVER foreign_server
        OPTIONS (user 'foreign_user', password 'password');
</pre><p>
  </p><p>
   Now it is possible to create a foreign table with
   <a class="xref" href="sql-createforeigntable.html" title="CREATE FOREIGN TABLE"><span class="refentrytitle">CREATE FOREIGN TABLE</span></a>.  In this example we
   wish to access the table named <code class="