diff options
Diffstat (limited to 'doc/src/sgml/ref/create_server.sgml')
-rw-r--r-- | doc/src/sgml/ref/create_server.sgml | 22 |
1 files changed, 8 insertions, 14 deletions
diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml index 60744b2d463..3e6127a3898 100644 --- a/doc/src/sgml/ref/create_server.sgml +++ b/doc/src/sgml/ref/create_server.sgml @@ -110,11 +110,10 @@ CREATE SERVER <replaceable class="parameter">server_name</replaceable> [ TYPE '< <title>Notes</title> <para> - When using the <application>dblink</application> module - (see <xref linkend="dblink">), the foreign server name can be used + When using the <xref linkend="dblink"> module, + a foreign server's name can be used as an argument of the <xref linkend="contrib-dblink-connect"> - function to indicate the connection parameters. See also there for - more examples. It is necessary to have + function to indicate the connection parameters. It is necessary to have the <literal>USAGE</literal> privilege on the foreign server to be able to use it in this way. </para> @@ -124,19 +123,13 @@ CREATE SERVER <replaceable class="parameter">server_name</replaceable> [ TYPE '< <title>Examples</title> <para> - Create a server <literal>foo</> that uses the built-in foreign-data - wrapper <literal>default</>: + Create a server <literal>myserver</> that uses the + foreign-data wrapper <literal>postgres_fdw</>: <programlisting> -CREATE SERVER foo FOREIGN DATA WRAPPER "default"; +CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432'); </programlisting> + See <xref linkend="postgres-fdw"> for more details. </para> - - <para> - Create a server <literal>myserver</> that uses the - foreign-data wrapper <literal>pgsql</>: -<programlisting> -CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'foodb', port '5432'); -</programlisting></para> </refsect1> <refsect1> @@ -154,6 +147,7 @@ CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'f <member><xref linkend="sql-alterserver"></member> <member><xref linkend="sql-dropserver"></member> <member><xref linkend="sql-createforeigndatawrapper"></member> + <member><xref linkend="sql-createforeigntable"></member> <member><xref linkend="sql-createusermapping"></member> </simplelist> </refsect1> |