Cloud

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

oid

int

The OID of the catalog.

srvname

text

The name of the catalog, such as default_redpanda_catalog.

srvowner

int

Unused. This column is always 0.

srvfdw

int

The OID of the foreign data wrapper that the catalog uses. References pg_foreign_data_wrapper.oid.

srvtype

text

Unused. This column is always empty.

srvversion

text

Unused. This column is always empty.

srvacl

text

Unused. This column is always empty.

srvoptions

text

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;