Backend Compatibility

Besides compatibility with the PostgreSQL SQL dialect and protocol, CedarDB also supports a large part of the PostgreSQL backend system catalog, which is often used by external tools and clients to interact with the database system. This page provides an overview of the currently supported system tables and views.

🟢 Fully supported features.
🟡 Since CedarDB does not share the PostgreSQL codebase and internal structures, some tables and views cannot have meaningful content and exist only for compatibility reasons.
🔴 Catalog entries without meaningful content.

System Tables

Feature	Support State	Details
pg_aggregate	🟡	Stores information about aggregate functions.
pg_am	🟢	Contains information about access methods; amhandler is unset.
pg_amop	🟡	Stores information about operators associated with access methods.
pg_amproc	🟡	Contains information about support procedures associated with access methods.
pg_attrdef	🟢	Stores column default values.
pg_attribute	🟢	Contains information about table columns.
pg_authid	🟢	Stores information about database roles.
pg_auth_members	🟡	Tracks role memberships.
pg_cast	🟡	Contains information about type casts.
pg_class	🟢	Stores information about tables, indexes, sequences, and other relations.
pg_collation	🟢	Contains information about collations.
pg_constraint	🟢	Stores information about table constraints.
pg_conversion	🟡	Contains information about encoding conversions.
pg_database	🟢	Stores information about databases.
pg_db_role_setting	🟡	Contains per-role and per-database configuration settings.
pg_default_acl	🟡	Stores default access privileges.
pg_depend	🟡	Tracks dependencies between database objects.
pg_description	🟢	Stores optional descriptions (comments) for database objects.
pg_enum	🟡	Contains information about enum types.
pg_event_trigger	🟡	Stores information about event triggers.
pg_extension	🟡	Contains information about installed extensions.
pg_foreign_data_wrapper	🟡	Stores information about foreign-data wrappers.
pg_foreign_server	🟡	Contains information about foreign servers.
pg_foreign_table	🟡	Stores information about foreign tables.
pg_index	🟢	Contains information about indexes.
pg_inherits	🟡	Tracks table inheritance hierarchies.
pg_init_privs	🟡	Stores initial privileges of database objects.
pg_language	🟡	Contains information about procedural languages.
pg_largeobject	🟡	Stores large object data.
pg_largeobject_metadata	🟡	Contains metadata for large objects.
pg_namespace	🟢	Stores information about schemas.
pg_opclass	🟢	Contains information about operator classes.
pg_operator	🟡	Stores information about operators.
pg_opfamily	🟡	Contains information about operator families.
pg_parameter_acl	🟡	Stores access privileges for server parameters.
pg_partitioned_table	🟡	Contains information about partitioned tables.
pg_policy	🟡	Stores information about row-level security policies.
pg_proc	🟢	Contains information about functions and procedures.
pg_publication	🟡	Contains all publications created in the database.
pg_publication_namespace	🟡	Maps schemas to publications, supporting a many-to-many relationship.
pg_publication_rel	🟡	Maps relations (tables) to publications, supporting a many-to-many relationship.
pg_range	🟡	Stores information about range types, supplementing entries in pg_type.
pg_replication_origin	🟡	Contains all replication origins created, shared across all databases in a cluster.
pg_rewrite	🟡	Stores rewrite rules for tables and views.
pg_seclabel	🟡	Stores security labels on database objects, manipulable with the SECURITY LABEL command.
pg_sequence	🟢	Contains information about sequences, with additional details in pg_class.
pg_shdepend	🟡	Records dependency relationships between database objects and shared objects, like roles.
pg_shdescription	🟡	Stores optional descriptions (comments) for shared database objects.
pg_shseclabel	🟡	Stores security labels for shared database objects.
pg_statistic	🟡	Stores statistical data about the contents of the database, used by the query planner.
pg_statistic_ext	🟡	Stores extended statistics for columns, aiding in more accurate query planning.
pg_statistic_ext_data	🟡	Contains data for extended statistics objects.
pg_subscription	🟡	Stores information about logical replication subscriptions.
pg_subscription_rel	🟡	Tracks the state of individual relations in a subscription.
pg_tablespace	🟡	Stores information about the available tablespaces.
pg_transform	🟡	Stores information about transforms between data types and procedural languages.
pg_trigger	🟡	Contains information about triggers on tables.
pg_ts_config	🟡	Stores text search configurations.
pg_ts_config_map	🟡	Maps text search configurations to dictionaries.
pg_ts_dict	🟡	Stores text search dictionaries.
pg_ts_parser	🟡	Contains text search parsers.
pg_ts_template	🟡	Stores text search templates.
pg_type	🟢	Stores information about data types.
pg_user_mapping	🟡	Contains information about user mappings for foreign data access.

System Views

Feature	Support State	Details
pg_available_extensions	🔴	Lists available extensions.
pg_available_extension_versions	🔴	Shows available versions of extensions.
pg_backend_memory_contexts	🔴	Displays memory contexts of the backend.
pg_config	🔴	Provides access to compile-time configuration parameters.
pg_cursors	🔴	Lists open cursors.
pg_file_settings	🔴	Summarizes contents of configuration files.
pg_group	🟢	Displays groups of database users.
pg_hba_file_rules	🔴	Summarizes client authentication configuration file contents.
pg_indexes	🟢	Shows information about indexes.
pg_locks	🟡	Displays locks currently held or awaited.
pg_matviews	🟡	Lists materialized views.
pg_policies	🟡	Displays information about policies.
pg_prepared_statements	🟡	Lists prepared statements.
pg_prepared_xacts	🔴	Shows prepared transactions.
pg_publication_tables	🔴	Displays publications and their associated tables.
pg_replication_origin_status	🔴	Provides information about replication origins, including replication progress.
pg_replication_slots	🔴	Displays replication slot information.
pg_roles	🟢	Lists database roles.
pg_rules	🔴	Shows information about rules.
pg_seclabels	🔴	Displays security labels.
pg_sequences	🟡	Lists sequences.
pg_settings	🟢	Provides access to parameter settings.
pg_shadow	🟢	Displays database users.
pg_shmem_allocations	🔴	Shows shared memory allocations.
pg_stats	🔴	Provides planner statistics.
pg_stats_ext	🔴	Displays extended planner statistics.
pg_stats_ext_exprs	🔴	Shows extended planner statistics for expressions.
pg_tables	🟢	Lists tables.
pg_timezone_abbrevs	🟢	Displays time zone abbreviations.
pg_timezone_names	🟢	Lists time zone names.
pg_user	🟢	Shows database users.
pg_user_mappings	🔴	Displays user mappings.
pg_views	🟢	Lists views.

Ecosystem and Client Compatibility Roadmap