Multicolumn Indexes
  • References/Database/PostgreSQL/Indexes

An index can be defined on more than one column of a table. For example, if you have a table of this form:

2025-01-10 15:47:30
VALUES Lists
  • References/Database/PostgreSQL/Queries

VALUES provides a way to generate a "constant table" that can be used in a query without having to actually create and

2025-01-10 15:47:30
Continuous Archiving and Point-in-Time Recovery (PITR)
  • References/Database/PostgreSQL/Backup and Restore

At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory

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

NameUNLISTEN -- stop listening for a notification Synopsis

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

Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number

2025-01-10 15:47:30
Monitoring: Standard Unix Tools
  • References/Database/PostgreSQL/Monitoring

On most Unix platforms, PostgreSQL modifies its command title as reported by ps, so that individual server processes

2025-01-10 15:47:30
Monitoring: Progress Reporting
  • References/Database/PostgreSQL/Monitoring

PostgreSQL has the ability to report the progress of certain commands during command execution. Currently, the only command which supports

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

The catalog pg_conversion describes encoding conversion procedures. See

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

NameROLLBACK -- abort the current transaction Synopsis

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

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data

2025-01-10 15:47:30