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

The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions 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_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