.psqlrc
author Oleksandr Gavenko <gavenkoa@gmail.com>
Mon, 01 Jan 2024 20:53:49 +0200
changeset 1039 78cdb4a057e3
parent 929 615c58735e09
permissions -rw-r--r--
Create symlink from ~/.bash_profile for login shell to activate my ~/.bashrc.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
928
2b706bde17c2 Enable switching to wide line format of SQL output when necessary by psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff changeset
     1
\x auto
929
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     2
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     3
-- \pset pager off
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     4
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     5
\pset null '[NULL]'
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     6
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     7
-- better error context
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     8
\set VERBOSITY verbose
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
     9
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
    10
\set HISTCONTROL ignoredups
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
    11
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
    12
\set COMP_KEYWORD_CASE upper
615c58735e09 Added null displaying, HISTCONTROL, upper case completion to psql.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents: 928
diff changeset
    13