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

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48.

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

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their

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

The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently

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

The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of

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

The catalog pg_depend records the dependency relationships between database objects. This information allows DROP

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

The catalog pg_default_acl stores initial privileges to be assigned to newly created objects.

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

The catalog pg_conversion describes encoding conversion procedures. See

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

The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is

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

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the

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

The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in

2025-01-10 15:47:30