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

The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all

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

The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the

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

The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.

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

The catalog pg_trigger stores triggers on tables and views. See CREATE

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

The pg_available_extensions view lists the extensions that are available for installation. See also the

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

The catalog pg_pltemplate stores "template" information for procedural languages. A template for a language allows

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

The view pg_stats provides access to the information stored in the

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

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

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