pg_trigger_depth() — PostgreSQL system administration function
pg_trigger_depth(): current trigger depth. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
Function Category: System Administration Functions
pg_try_advisory_lock() — PostgreSQL system administration function
pg_try_advisory_lock(): obtain exclusive advisory lock if available. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_try_advisory_xact_lock() — PostgreSQL system administration function
pg_try_advisory_xact_lock(): obtain exclusive advisory lock if available. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_type_is_visible() — PostgreSQL system administration function
pg_type_is_visible(): is type visible in search path?. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_typeof() — PostgreSQL system administration function
pg_typeof(): type of the argument. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_visible_in_snapshot() — PostgreSQL system administration function
pg_visible_in_snapshot(): is xid8 visible in snapshot?. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_wal_lsn_diff() — PostgreSQL system administration function
pg_wal_lsn_diff(): difference in bytes, given two wal locations. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative…
pg_wal_replay_pause() — PostgreSQL system administration function
pg_wal_replay_pause(): pause wal replay. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.
pg_wal_replay_resume() — PostgreSQL system administration function
pg_wal_replay_resume(): resume wal replay, if it was paused. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative…
pg_walfile_name() — PostgreSQL system administration function
pg_walfile_name(): wal filename, given a wal location. PostgreSQL system administration functions — signature, volatility, version applicability and an illustrative example.