DragonFly On-Line Manual Pages

Search: Section:  

CREATE SERVER(7)        PostgreSQL 9.5.0 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.5.0                     2016                     CREATE SERVER(7)

Search: Section: