pg_catalog
Materialize has compatibility shims for the following relations from PostgreSQL’s system catalog:
pg_am
pg_attribute
pg_auth_members
pg_class
pg_collation
pg_constraint
pg_database
pg_description
pg_enum
pg_index
pg_inherits
pg_matviews
pg_namespace
pg_policy
pg_proc
pg_range
pg_roles
pg_settings
pg_tables
pg_type
pg_views
pg_authid
These compatibility shims are largely incomplete. Most are lacking some columns
that are present in PostgreSQL, or if they do include the column the result set
its value may always be NULL
. The precise nature of the incompleteness is
intentionally undocumented. New tools developed against Materialize should use
the documented mz_catalog
API instead.
If you are having trouble making a PostgreSQL tool work with Materialize, please
file a GitHub issue. Many PostgreSQL tools can be made to work with
Materialize with minor changes to the pg_catalog
compatibility shim.