pg_prewarm
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the

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

NameDROP RULE -- remove a rewrite rule Synopsis

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

The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row

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
CREATE AGGREGATE
  • References/Database/PostgreSQL/Commands

NameCREATE AGGREGATE -- define a new aggregate function Synopsis

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

NameDROP INDEX -- remove an index Synopsis

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

The money type stores a currency amount with a fixed fractional precision; see Table 8-3. The fractional precision is determined by the database's

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

NameALTER TABLE -- change the definition of a table Synopsis

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

NameCREATE TYPE -- define a new data type Synopsis

2025-01-10 15:47:30
Internals//GIN Indexes: Implementation
  • References/Database/PostgreSQL/Internals/GIN Indexes

Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member

2025-01-10 15:47:30