top of page

PostgreSQL:

CREATE SERVER

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

Example

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

bottom of page