pg_foreign_server
The pg_foreign_server stores one row for each Redpanda catalog and Iceberg catalog in the database. It mimics the pg_foreign_server PostgreSQL system catalog.
The catalogs that a role sees follow the rules in Tables in Redpanda and Iceberg catalogs.
Columns
The following columns are available for querying in pg_foreign_server:
| Column | Type | Description |
|---|---|---|
|
|
The OID of the catalog. |
|
|
The name of the catalog, such as |
|
|
Unused. This column is always |
|
|
The OID of the foreign data wrapper that the catalog uses. References |
|
|
Unused. This column is always empty. |
|
|
Unused. This column is always empty. |
|
|
Unused. This column is always empty. |
|
|
Unused. This column is always empty. |
Examples
List each catalog with its foreign data wrapper:
SELECT s.srvname, w.fdwname
FROM pg_foreign_server s
JOIN pg_foreign_data_wrapper w ON w.oid = s.srvfdw;