Catalogs: pg_replication_origin_status
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication

2025-01-10 15:47:30
Catalogs: pg_language
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_language registers languages in which you can write functions or stored procedures. See

2025-01-10 15:47:30
Catalogs: pg_prepared_xacts
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see

2025-01-10 15:47:30
Catalogs: pg_shdepend
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows

2025-01-10 15:47:30
Catalogs: pg_matviews
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_matviews provides access to useful information about each materialized view in the database.

2025-01-10 15:47:30
Catalogs: pg_indexes
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_indexes provides access to useful information about each index in the database.

2025-01-10 15:47:30
Catalogs: pg_constraint
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated

2025-01-10 15:47:30
Catalogs: pg_ts_template
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search

2025-01-10 15:47:30
Catalogs: pg_statistic
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by

2025-01-10 15:47:30
Catalogs: pg_ts_config_map
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output

2025-01-10 15:47:30