Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PG_FOREIGN_SERVER
PG_FOREIGN_SERVER
PG_FOREIGN_SERVER records the foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.
| Name | Type | Reference | Description |
|---|---|---|---|
| oid | oid | - | Row identifier (hidden attribute; must be explicitly selected) |
| srvname | name | - | Name of the foreign server |
| srvowner | oid | PG_AUTHID.oid | Owner of the foreign server |
| srvfdw | oid | OID of the foreign-data wrapper of this foreign server | |
| srvtype | text | - | Type of the server (optional) |
| srvversion | text | - | Version of the server (optional) |
| srvacl | aclitem[] | - | Access permissions |
| srvoptions | text[] | - | Option used for foreign servers. It is a keyword=value string. |
Parent topic: System Catalogs
Last Article: PG_FOREIGN_DATA_WRAPPER
Next Article: PG_FOREIGN_TABLE
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.