System Catalog Schema

The Postgres pg_catalog schema provides access to a variety of database metadata useful for inspecting your database and also used by database tooling. Doltgres provides a subset of the data available in pg_catalog, as described below. In general, all tables from Postgres's pg_catalog exist, with the correct schema, but not all data is populated. If you need support for pg_catalog metadata that is available in Postgres, but not yet available in Doltgres, please open a GitHub issue to let us know what you need.

Tables

Views

ViewParsesPopulated

🟠

🟠

🟠

System Information Functions

See detailed list in the Postgres docs.

Supported functions work as SELECT [function], but not yet as SELECT * FROM [function].

FunctionSupportedNotes and limitations

current_catalog

current_database()

current_query()

current_role

current_schema[()]

current_schemas(bool)

current_user

inet_client_addr()

inet_client_port()

inet_server_addr()

inet_server_port()

pg_backend_pid()

pg_blocking_pids(integer)

pg_conf_load_time()

pg_current_logfile([text])

pg_my_temp_schema()

pg_is_other_temp_schema(oid)

pg_jit_available()

pg_listening_channels()

pg_notification_queue_usage()

pg_postmaster_start_time()

pg_safe_snapshot_blocking_pids(integer)

pg_trigger_depth()

session_user

user

version()

🟠

Parses but version is inaccurate

System Catalog Information Functions

See detailed list in the Postgres docs.

FunctionSupportedNotes and limitations

format_type(oid, integer)

pg_char_to_encoding(name)

pg_encoding_to_char(integer)

pg_get_catalog_foreign_keys()

pg_get_constraintdef(oid [, boolean])

pg_get_expr(pg_node_tree, oid [, boolean])

pg_get_functiondef(oid)

pg_get_function_arguments(oid)

pg_get_function_identity_arguments(oid)

pg_get_function_result(oid)

pg_get_indexdef(oid [, integer, boolean])

pg_get_keywords()

pg_get_ruledef(oid [, boolean])

pg_get_serial_sequence(text, text)

pg_get_statisticsobjdef(oid)

pg_get_triggerdef(oid [, boolean])

pg_get_userbyid(oid)

pg_get_viewdef(oid [, boolean])

pg_get_viewdef(text [, boolean])

pg_index_column_has_property(regclass, text)

pg_indexam_has_property(oid, text)

pg_options_to_table(text[])

pg_settings_get_flags(text)

pg_tablespace_databases(oid)

pg_tablespace_location(pod)

pg_typeof("any")

COLLATION FOR("any)

to_regclass(text)

to_regcollation(text)

to_regnamespace(text)

to_regoper(text)

to_regoperator(text)

to_regproc(text)

to_regprocedure(text)

to_regrole(text)

to_regtype(text)

Schema Visibility Inquiry Functions

See detailed list in the Postgres docs.

FunctionSupportedNotes and limitations

pg_collation_is_visible(oid)

pg_conversion_is_visible(oid)

pg_function_is_visible(oid)

pg_opclass_is_visible(oid)

pg_operator_is_visible(oid)

pg_opfamily_is_visible(oid)

pg_statistics_obj_is_visible(oid)

pg_table_is_visible(oid)

pg_ts_config_is_visible(oid)

pg_ts_dict_is_visible(oid)

pg_ts_parser_is_visible(oid)

pg_ts_template_is_visible(oid)

pg_type_is_visible(oid)

Comment Information Functions

See detailed list in the Postgres docs.

FunctionSupportedNotes and limitations

col_description(oid, integer)

obj_description(oid, name)

obj_description(oid)

shobj_description(oid, name)

Last updated