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

The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41

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

The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but

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

The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows

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

The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement

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

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

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

The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration

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

The view pg_user provides access to information about database users. This is simply a publicly readable view of

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

The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

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

The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

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

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

2025-01-10 15:47:30