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

NameUPDATE -- update rows of a table Synopsis

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
Catalogs: pg_shadow
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

2025-01-10 15:47:30
Internals//Index Access Method: Index Cost Estimation Functions
  • References/Database/PostgreSQL/Internals/Index Access Method

The amcostestimate function is given information describing a possible index scan, including lists of WHERE and ORDER BY clauses that have been

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

The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is

2025-01-10 15:47:30
Full Text Search: Limitations
  • References/Database/PostgreSQL/Full Text Search

The current limitations of PostgreSQL's text search features are: The

2025-01-10 15:47:30
Comparison of Different Solutions
  • References/Database/PostgreSQL/High Availability

Shared Disk Failover Shared disk failover avoids synchronization overhead by having only one copy of the database. It uses a single

2025-01-10 15:47:30
WAL Internals
  • References/Database/PostgreSQL/Write-Ahead Log

WAL is automatically enabled; no action is required from the administrator except ensuring that the disk-space requirements for the

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

The view pg_roles provides access to information about database roles. This is simply a publicly readable view of

2025-01-10 15:47:30