pg_catalog

Materialize has compatibility shims for the following relations from PostgreSQL’s system catalog:

• pg_aggregate
• pg_am
• pg_attribute
• pg_auth_members
• pg_authid
• pg_class
• pg_collation
• pg_constraint
• pg_depend
• pg_database
• pg_description
• pg_enum
• pg_event_trigger
• pg_extension
• pg_index
• pg_indexes
• pg_inherits
• pg_language
• pg_locks
• pg_matviews
• pg_namespace
• pg_policy
• pg_proc
• pg_range
• pg_rewrite
• pg_roles
• pg_settings
• pg_shdescription
• pg_tables
• pg_tablespace
• pg_timezone_abbrevs
• pg_timezone_names
• pg_trigger
• pg_type
• pg_user
• pg_views

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.