CREATE SERVER — define a new foreign server
CREATE SERVERdefines 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 requiresUSAGEprivilege on the foreign-data wrapper being used.
IF NOT EXISTS
Do not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like the one that would have been created.
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.
When using thedblinkmodule, a foreign server's name can be used as an argument of thedblink_connectfunction to indicate the connection parameters. It is necessary to have theUSAGEprivilege on the foreign server to be able to use it in this way.
Create a servermyserverthat uses the foreign-data wrapperpostgres_fdw:
Seepostgres_fdwfor more details.
CREATE SERVERconforms to ISO/IEC 9075-9 (SQL/MED).
,
,
,
,