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
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
JSON Types
  • References/Database/PostgreSQL/Data Types

JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159.

2025-01-10 15:47:30
Indexes on Expressions
  • References/Database/PostgreSQL/Indexes

An index column need not be just a column of the underlying table, but can be a function or scalar expression computed from one or more columns of the table. This feature is

2025-01-10 15:47:30
ALTER OPERATOR
  • References/Database/PostgreSQL/Commands

NameALTER OPERATOR -- change the definition of an operator Synopsis

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

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

2025-01-10 15:47:30
XML Functions
  • References/Database/PostgreSQL/Functions/XML

The functions and function-like expressions described in this section operate on values of type xml. Check

2025-01-10 15:47:30
Authentication Problems
  • References/Database/PostgreSQL/Client Authentication

Authentication failures and related problems generally manifest themselves through error messages like the following:

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

The executor takes the plan created by the planner/optimizer and recursively processes it to extract the required set of rows. This is essentially

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