Help Center/ DataArts Fabric/ Developer Guide/ System Catalogs/ PG_FOREIGN_SERVER

Updated on 2025-08-25 GMT+08:00

View PDF

PG_FOREIGN_SERVER

PG_FOREIGN_SERVER stores foreign server definitions. A foreign server describes an external data source, such as a remote server. Foreign servers are accessed through foreign-data wrappers.

**Table 1** PG_FOREIGN_SERVER columns
Column	Type	Reference	Description
oid	oid	-	Row identifier (a hidden attribute that is only shown upon explicit selection).
srvname	name	-	Name of the foreign server.
srvowner	oid	PG_AUTHID.oid	Owner of the foreign server.
srvfdw	oid	PG_FOREIGN_DATA_WRAPPER.oid	OID of the foreign-data wrapper of this foreign server.
srvtype	text	-	Server type (optional).
srvversion	text	-	Server version (optional).
srvacl	aclitem[]	-	Access permissions.
srvoptions	text[]	-	Foreign server-specific options, using strings in the keyword=value format.

Parent topic: System Catalogs

Previous topic: PG_FOREIGN_DATA_WRAPPER

Next topic: PG_NAMESPACE

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.