—
NAME
DISCARD - discard session state
SYNOPSIS
bash
DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }DESCRIPTION
DISCARD releases internal resources associated with a database session. This command is useful for partially or fully resetting the session's state. There are several subcommands to release different types of resources; the DISCARD ALL variant subsumes all the others, and also resets additional state.
PARAMETERS
PLANS
SEQUENCES
TEMPORARY or TEMP
ALL
bash
CLOSE ALL;
SET SESSION AUTHORIZATION DEFAULT;
RESET ALL;
DEALLOCATE ALL;
UNLISTEN *;
SELECT pg_advisory_unlock_all();
DISCARD PLANS;
DISCARD TEMP;
DISCARD SEQUENCES;NOTES
DISCARD ALL cannot be executed inside a transaction block.
COMPATIBILITY
DISCARD is a PostgreSQL extension.