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

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

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

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL

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

Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template

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

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the

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

The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See

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

The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the

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

The catalog pg_range stores information about range types. This is in addition to the types' entries in

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

The catalog pg_largeobject holds the data making up "large objects". A large object is identified by an OID assigned

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

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection

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

The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the

2025-01-10 15:47:30