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

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

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

The catalog pg_extension stores information about the installed extensions. See Section 36.15 for details about extensions.

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

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

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

The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view

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

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

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