Catalogs: pg_replication_origin
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48.

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

Namepg_receivexlog -- stream transaction logs from a PostgreSQL server

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

NameALTER COLLATION -- change the definition of a collation Synopsis

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

NameCREATE EXTENSION -- install an extension Synopsis

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
Full Text Search: Testing and Debugging Text Search
  • References/Database/PostgreSQL/Full Text Search

The behavior of a custom text search configuration can easily become confusing. The functions described in this section are useful for testing text search objects. You can

2025-01-10 15:47:30
Alternative Method for Log Shipping
  • References/Database/PostgreSQL/High Availability

An alternative to the built-in standby mode described in the previous sections is to use a restore_command that polls the archive location. This

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

The executor takes the plan created by the planner/optimizer and recursively processes it to extract the required set of rows. This is essentially

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

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their

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

NameDROP OPERATOR CLASS -- remove an operator class Synopsis

2025-01-10 15:47:30