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

The file_fdw module provides the foreign-data wrapper file_fdw, which can be used to access data files in the server's

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

NameCREATE TRIGGER -- define a new trigger Synopsis

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

NameDROP ROLE -- remove a database role Synopsis

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

Namepgbench -- run a benchmark test on PostgreSQL

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

NameANALYZE -- collect statistics about a database Synopsis

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

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

The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as

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

NameALTER TYPE -- change the definition of a type Synopsis

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

Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. OIDs are not added to user-created tables

2025-01-10 15:47:30
Logical Operators
  • References/Database/PostgreSQL/Functions and Operators

The usual logical operators are available: AND OR

2025-01-10 15:47:30