Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
CREATE SERVER(7)	PostgreSQL 9.6.3 Documentation	      CREATE SERVER(7)

NAME
       CREATE_SERVER - define a	new foreign server

SYNOPSIS
       CREATE SERVER server_name [ TYPE	'server_type' ]	[ VERSION 'server_version' ]
	   FOREIGN DATA	WRAPPER	fdw_name
	   [ OPTIONS ( option 'value' [, ... ] ) ]

DESCRIPTION
       CREATE SERVER defines a new foreign server. The user who	defines	the
       server becomes its owner.

       A foreign server	typically encapsulates connection information that a
       foreign-data wrapper uses to access an external data resource.
       Additional user-specific	connection information may be specified	by
       means of	user mappings.

       The server name must be unique within the database.

       Creating	a server requires USAGE	privilege on the foreign-data wrapper
       being used.

PARAMETERS
       server_name
	   The name of the foreign server to be	created.

       server_type
	   Optional server type, potentially useful to foreign-data wrappers.

       server_version
	   Optional server version, potentially	useful to foreign-data
	   wrappers.

       fdw_name
	   The name of the foreign-data	wrapper	that manages the server.

       OPTIONS ( option	'value'	[, ... ] )
	   This	clause specifies the options for the server. The options
	   typically define the	connection details of the server, but the
	   actual names	and values are dependent on the	server's foreign-data
	   wrapper.

NOTES
       When using the dblink module, a foreign server's	name can be used as an
       argument	of the dblink_connect(3) function to indicate the connection
       parameters. It is necessary to have the USAGE privilege on the foreign
       server to be able to use	it in this way.

EXAMPLES
       Create a	server myserver	that uses the foreign-data wrapper
       postgres_fdw:

	   CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname	'foodb', port '5432');

       See postgres_fdw	for more details.

COMPATIBILITY
       CREATE SERVER conforms to ISO/IEC 9075-9	(SQL/MED).

SEE ALSO
       ALTER SERVER (ALTER_SERVER(7)), DROP SERVER (DROP_SERVER(7)), CREATE
       FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE FOREIGN
       TABLE (CREATE_FOREIGN_TABLE(7)),	CREATE USER MAPPING
       (CREATE_USER_MAPPING(7))

PostgreSQL 9.6.3		     2017		      CREATE SERVER(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | NOTES | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=CREATE_SERVER&sektion=7&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help