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_operator
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_operator stores information about operators. See CREATE

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

The view pg_tables provides access to useful information about each table in the database.

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_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_aggregate
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

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_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_collation
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories

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