• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

pg_foreign_server

pg_foreign_server is a system catalogue table storing foreign server definitions for FDWs defined with the CREATE SERVER command.

pg_foreign_server was introduced in PostgreSQL 8.4.

psql command

\des lists foreign servers.

Definition by PostgreSQL version

          Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Collation | Nullable | Default
------------+-----------+-----------+----------+---------
 oid        | oid       |           | not null |
 srvname    | name      |           | not null |
 srvowner   | oid       |           | not null |
 srvfdw     | oid       |           | not null |
 srvtype    | text      | C         |          |
 srvversion | text      | C         |          |
 srvacl     | aclitem[] |           |          |
 srvoptions | text[]    | C         |          |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

          Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Collation | Nullable | Default
------------+-----------+-----------+----------+---------
 oid        | oid       |           | not null |
 srvname    | name      |           | not null |
 srvowner   | oid       |           | not null |
 srvfdw     | oid       |           | not null |
 srvtype    | text      | C         |          |
 srvversion | text      | C         |          |
 srvacl     | aclitem[] |           |          |
 srvoptions | text[]    | C         |          |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

          Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Collation | Nullable | Default
------------+-----------+-----------+----------+---------
 srvname    | name      |           | not null |
 srvowner   | oid       |           | not null |
 srvfdw     | oid       |           | not null |
 srvtype    | text      |           |          |
 srvversion | text      |           |          |
 srvacl     | aclitem[] |           |          |
 srvoptions | text[]    |           |          |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

          Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Collation | Nullable | Default
------------+-----------+-----------+----------+---------
 srvname    | name      |           | not null |
 srvowner   | oid       |           | not null |
 srvfdw     | oid       |           | not null |
 srvtype    | text      |           |          |
 srvversion | text      |           |          |
 srvacl     | aclitem[] |           |          |
 srvoptions | text[]    |           |          |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Table "pg_catalog.pg_foreign_server"
   Column   |   Type    | Modifiers
------------+-----------+-----------
 srvname    | name      | not null
 srvowner   | oid       | not null
 srvfdw     | oid       | not null
 srvtype    | text      |
 srvversion | text      |
 srvacl     | aclitem[] |
 srvoptions | text[]    |
Indexes:
    "pg_foreign_server_name_index" UNIQUE, btree (srvname)
    "pg_foreign_server_oid_index" UNIQUE, btree (oid)
    

Change history

This table has not been modified since it was first added in PostgreSQL 8.4.

• PostgreSQL 8.4
  • added (commit cae565e5)

Examples

postgres=# CREATE SERVER fdw_test
  FOREIGN DATA WRAPPER postgres_fdw
  OPTIONS (
    host 'remotehost',
    port '5432,
    dbname 'postgres'
 );
CREATE SERVER

postgres=# SELECT * FROM pg_foreign_server ;
-[ RECORD 1 ]------------------------------------------
oid        | 16459
srvname    | fdw_test
srvowner   | 10
srvfdw     | 16458
srvtype    |
srvversion |
srvacl     |
srvoptions | {host=remotehost,port=5432,dbname=postgres}

References

Categories

See also