.psqlrc

\set QUIET 1
\pset null '[null]'
\set QUIET 0
\set G '\\x\\g\\x'
\set PROMPT1 '%n@%M:%> %/%x%# '
\set PROMPT2 '# '
\set HISTFILE ~/.psql_history- :DBNAME
\timing
\set tsize 'SELECT relname, relkind, pg_size_pretty(pg_relation_size(oid)) AS relation_size, pg_size_pretty(pg_total_relation_size(oid)) AS total_relation_size FROM pg_class WHERE relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = \'public\') AND relkind NOT IN (\'v\', \'c\') ORDER BY pg_relation_size(oid) DESC;'
\set dsize 'SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) FROM pg_database ORDER BY pg_database_size(pg_database.datname) DESC;'