My glamorous .psqlrc

my-glamorous-psqlrc.md

I use psql a lot when interacting with Postgres databases. I recently took the time to glam up my ~/.pgsqlrc and the results are pretty 🔥🔥🔥.

Obviously, I have the nord theme there. Anyhoo, hope you, reader, might find this useful in your own quest for terminal bliss.

\set QUIET on
\set HISTFILE ~/.psql_history- :HOST - :DBNAME
\set PROMPT1 '%[%033[1;37m%] %[%033[1;36m%]%n%[%033[0m%]@%[%033[1;32m%]%/%[%033[0m%] %[%033[1;35m%]❯ %[%033[0m%]'
\set PROMPT2 '%[%033[1;35m%]↪ %[%033[0m%]'
\encoding unicode
\pset linestyle unicode
\pset border 2
\pset null ∅
\x auto
\set HISTFILE ~/.psql_history/psql_history- :HOST - :DBNAME
\pset pager always
\set QUIET off
\echo ''
\echo '\033[1;34m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\033[0m'
\echo '\033[1;37m\033[0m \033[1;32m Database: \033[0m\033[1;36m' :DBNAME '\033[0m'
\echo '\033[1;37m\033[0m \033[1;32m User:     \033[0m\033[1;33m' :USER '\033[0m'
\echo '\033[1;37m\033[0m \033[1;32m Host:     \033[0m\033[1;35m' :HOST '\033[0m'
\echo '\033[1;37m\033[0m \033[1;32m Port:     \033[0m\033[1;31m' :PORT '\033[0m'
\echo '\033[1;34m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\033[0m'
\echo ''

🔥