CREATE SERVER SQL - Language Statements CREATE SERVER define a new foreign server CREATE SERVER CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ] FOREIGN DATA WRAPPER fdwname [ OPTIONS ( option 'value' [, ... ] ) ] CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner. The server name must be unique within the database. Creating a server requires USAGE privilege on the foreign-data wrapper being used. 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 ( 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. 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'); CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED).