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

The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the

2025-01-10 15:47:30
Server Configuration: Client Connection Defaults
  • References/Database/PostgreSQL/Server Configuration

19.11.1. Statement Behavior search_path (string)

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

NameUPDATE -- update rows of a table Synopsis

2025-01-10 15:47:30
Internals//Physical Storage: Visibility Map
  • References/Database/PostgreSQL/Internals/Physical Storage

Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of

2025-01-10 15:47:30
Date/Time Types
  • References/Database/PostgreSQL/Data Types

PostgreSQL supports the full set of SQL date and time types, shown in Table 8-9. The operations available

2025-01-10 15:47:30
ORDER BY
  • References/Database/PostgreSQL/Queries

After a query has produced an output table (after the select list has been processed) it can optionally be sorted. If sorting is not chosen, the rows will be returned in an

2025-01-10 15:47:30
DROP TYPE
  • References/Database/PostgreSQL/Commands

NameDROP TYPE -- remove a data type Synopsis

2025-01-10 15:47:30
Server Configuration: Connections and Authentication
  • References/Database/PostgreSQL/Server Configuration

19.3.1. Connection Settings listen_addresses (string)

2025-01-10 15:47:30
pg_test_timing
  • References/Database/PostgreSQL/Applications

Namepg_test_timing -- measure timing overhead Synopsis pg_test_timing

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

The following subsections describe the authentication methods in more detail. 20.3.1. Trust Authentication

2025-01-10 15:47:30