Cloud

pg_foreign_data_wrapper

The pg_foreign_data_wrapper stores the foreign data wrappers that Redpanda SQL uses to read tables in Redpanda catalogs and Iceberg catalogs. It mimics the pg_foreign_data_wrapper PostgreSQL system catalog.

This catalog always contains two rows:

  • redpanda (OID 602): The wrapper for Redpanda catalogs.

  • iceberg (OID 601): The wrapper for Iceberg catalogs.

Columns

The following columns are available for querying in pg_foreign_data_wrapper:

Column Type Description

oid

int

The OID of the foreign data wrapper.

fdwname

text

The name of the foreign data wrapper: redpanda or iceberg.

fdwowner

int

Unused. This column is always 0.

fdwhandler

int

Unused. This column is always 0.

fdwvalidator

int

Unused. This column is always 0.

fdwacl

text

Unused. This column is always empty.

fdwoptions

text

Unused. This column is always empty.