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

The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of

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

The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that

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

The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is

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

The catalog pg_depend records the dependency relationships between database objects. This information allows DROP

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

The view pg_policies provides access to useful information about each row-level security policy in the database.

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

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the

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

The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

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

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents

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

The catalog pg_proc stores information about functions (or procedures). See

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

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data

2025-01-10 15:47:30