aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_server.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/create_server.sgml')
-rw-r--r--doc/src/sgml/ref/create_server.sgml22
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>