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

Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists the available

2025-01-10 15:47:30
Type Conversion: UNION, CASE, and Related Constructs
  • References/Database/PostgreSQL/Type Conversion

SQL UNION constructs must match up possibly dissimilar types to become a single result set. The resolution algorithm is applied separately to each

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

The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways:

2025-01-10 15:47:30
Server Configuration: Lock Management
  • References/Database/PostgreSQL/Server Configuration

deadlock_timeout (integer) This is the amount of time, in milliseconds

2025-01-10 15:47:30
ALTER TEXT SEARCH DICTIONARY
  • References/Database/PostgreSQL/Commands

NameALTER TEXT SEARCH DICTIONARY -- change the definition of a text search dictionary

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

The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

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

NameGRANT -- define access privileges Synopsis

2025-01-10 15:47:30
seg
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

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

NameDROP COLLATION -- remove a collation Synopsis

2025-01-10 15:47:30