↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_export_snapshot

Read the PG 18 manual

Saves the transaction's current snapshot and returns a text string identifying the snapshot.

Reading PG 18current·documented in 16 of 27 versions, 9.2 to 20

Signatures & examples

pg_export_snapshot () → text
Saves the transaction's current snapshot and returns a text string identifying the snapshot. This string must be passed (outside the database) to clients that want to import the snapshot. The snapshot is available for import only until the end of the transaction that exported it.
Version history 2
  1. 12 → 13 changed
  2. 9.1 → 9.2 added

Definition snapshot: b7bd9cda · English manual source