The foreign_servers view provides information about foreign servers defined in the current database.
| Column name | Data type | Description |
|---|---|---|
foreign_server_catalog |
sql_identifier |
The name of the current database in which the foreign server is defined. |
foreign_server_name |
sql_identifier |
The name of the foreign server. |
foreign_data_wrapper_catalog |
sql_identifier |
The name of the current database containing the foreign-data wrapper used by the foreign server. |
foreign_data_wrapper_name |
sql_identifier |
The name of the foreign-data wrapper used by the foreign server. |
foreign_server_type |
character_data |
A foreign server type. The value is available if specified upon creation. |
foreign_server_version |
character_data |
A foreign server version. The value is available if specified upon creation. |
authorization_identifier |
sql_identifier |
The name of the foreign server owner. |