-
Notifications
You must be signed in to change notification settings - Fork 1
/
psqlrc
36 lines (27 loc) · 908 Bytes
/
psqlrc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
-- Don't display the "helpful" message on startup
\set QUIET 1
-- Null values are now represented as (null) in the database
\pset null '💩'
-- Custom prompt
-- Note: %# is # if you're a superuser, otherwise >
\set PROMPT1 '%[%033[1m%]%M %n@%/%#%[%033[0m%] '
-- Show how long each query takes to execute
\timing
-- Table display options
\pset linestyle unicode
-- Better output format
\x auto
\set VERBOSITY verbose
\set COMP_KEYWORD_CASE upper
-- If a command is run more than once in a row, only store it once in the
-- history.
\set HISTCONTROL ignoredups
\set HISTSIZE 20000
-- Use a separate history file per-database.
\set HISTFILE ~/.psql_history_ :DBNAME
\set QUIET
\echo 'Sup Richard'
\echo 'Type :version to see the PostgreSQL version.'
\echo 'Type :extensions to see the available extensions. \n'
\set version 'SELECT version();'
\set extensions 'select * from pg_available_extensions;'