Man Linux: Main Page and Category List

NAME

       CREATE SERVER - define a new foreign server

SYNOPSIS

       CREATE SERVER servername [ TYPE ’servertype’ ] [ VERSION ’serverversion’ ]
           FOREIGN DATA WRAPPER fdwname
           [ OPTIONS ( optionvalue’ [, ... ] ) ]

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

       servername
              The name of the foreign server to be created.

       servertype
              Optional server type.

       serverversion
              Optional server version.

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

       OPTIONS ( optionvalue[, ... ] )
              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 (see in the documentation), the foreign
       server name can  be  used  as  an  argument  of  the  dblink_connect(l)
       function to indicate the connection parameters. See also there for more
       examples. 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  foo  that  uses  the  built-in  foreign-data wrapper
       default:

       CREATE SERVER foo FOREIGN DATA WRAPPER "default";

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

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

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  USER
       MAPPING [create_user_mapping(7)]