Wiki / psql Commands / Scripting and assistance

\unset

Unsets (deletes) the psql variable name .

Reading PostgreSQL 18.6.

Description

Unsets (deletes) the psql variable name .

Client: psql 18.6
Case-sensitive spelling: \unset

Usage

\unset name

Spellings in this manual definition

Command	Documented suffix modifiers
\unset	None listed in this signature

Manual definition

\unset name

Unsets (deletes) the psql variable name.

Most variables that control psql's behavior cannot be unset; instead, an \unset command is interpreted as setting them to their default values. See Variables below.

Related entries

psql command-line options and complete manual

Documentation and source

18.6 English manual · app-psql.html

Source build

Version: 18.6
Build: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint: ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

Compare versions

PostgreSQL 12 → 13: changed.

--- PostgreSQL 12
+++ PostgreSQL 13
@@ -1,5 +1,5 @@
 {
-  "definition": "Unsets (deletes) the psql variable name . Most variables that control psql 's behavior cannot be unset; instead, an \\unset command is interpreted as setting them to their default values. See Variables , below.",
+  "definition": "Unsets (deletes) the psql variable name . Most variables that control psql 's behavior cannot be unset; instead, an \\unset command is interpreted as setting them to their default values. See Variables below.",
   "modifiers": [],
   "signature": "\\unset name",
   "spellings": [

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.