Content-Length: 88712 | pFad | http://postgrespro.com/docs/postgrespro/9.6/catalog-pg-foreign-server

Postgres Pro Standard : Documentation: 9.6: 48.24. pg_foreign_server : Postgres Professional

48.24. pg_foreign_server

The catalog pg_foreign_server stores 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.

Table 48.24. pg_foreign_server Columns

NameTypeReferencesDescription
oidoid Row identifier (hidden attribute; must be explicitly selected)
srvnamename Name of the foreign server
srvowneroidpg_authid.oidOwner of the foreign server
srvfdwoidpg_foreign_data_wrapper.oidOID of the foreign-data wrapper of this foreign server
srvtypetext Type of the server (optional)
srvversiontext Version of the server (optional)
srvaclaclitem[]  Access privileges; see GRANT and REVOKE for details
srvoptionstext[]  Foreign server specific options, as keyword=value strings









ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://postgrespro.com/docs/postgrespro/9.6/catalog-pg-foreign-server

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy