Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Catalogs/ PG_FOREIGN_SERVER

Updated on 2023-10-23 GMT+08:00

View PDF

PG_FOREIGN_SERVER

PG_FOREIGN_SERVER records 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 1** PG_FOREIGN_SERVER columns
Name	Type	Reference	Description
oid	oid	-	Row identifier (hidden attribute, which must be specified)
srvname	name	-	Name of a 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 on 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, expressed in a string in the format of keyword=value

Parent topic: System Catalogs

Previous topic: PG_FOREIGN_DATA_WRAPPER

Next topic: PG_FOREIGN_TABLE

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.