Environment

PAGER

If the query results do not fit on the screen, they are piped through this command. Typical values are more or less. The default is platform-dependent. The use of the pager can be disabled by using the \pset command.

PGDATABASE

Default connection database

PGHOST
PGPORT
PGUSER

Default connection parameters

VSQL_EDITOR
EDITOR
VISUAL

Editor used by the \e command. The variables are examined in the order listed; the first that is set is used.

SHELL

Command executed by the \! command.

TMPDIR

Directory for storing temporary files. The default is /tmp.