PostgreSQL propmt with user, hostname , port, dbname and current timestamp


bsms=# \set PROMPT1 '%[%033[1;33;40m%]%n@%M:%>::%/%R[%`date`]%[%033[0m%]%# '
bsms@[darkwater]:5432::bsms=[Wed Nov 30 01:14:48 EET 2011]# select now();
now
-------------------------------
2011-11-30 01:14:52.998601+02
(1 row)

bsms@[darkwater]:5432::bsms=[Wed Nov 30 01:14:53 EET 2011]#


Advertisement