↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Information Functions And Operators

pg_current_snapshot

Read the PG 18 manual

Returns a current snapshot, a data structure showing which transaction IDs are now in-progress.

Reading PG 18current·documented in 8 of 27 versions, 13 to 20

Signatures & examples

pg_current_snapshot () → pg_snapshot
Returns a current snapshot, a data structure showing which transaction IDs are now in-progress. Only top-level transaction IDs are included in the snapshot; subtransaction IDs are not shown; see Section 67.3 for details.
Version history 4
  1. 17 → 18 changed
  2. 16 → 17 changed
  3. 15 → 16 changed
  4. 12 → 13 added

Definition snapshot: b7bd9cda · English manual source