Kirk Wolak <wol...@gmail.com> writes: > Proposal: Simply add the %T (PROMPT variable) to output the current time > (HH24:MI:SS) into the prompt.
I'm not really convinced that %`date` isn't a usable solution for this, especially since it seems like a very niche requirement. The next person who wants it might well have a different desire than you for exactly what gets shown. The output of date can be customized, but a hard-wired prompt.c feature not so much. On the whole I'd rather not eat more of the limited namespace for psql prompt codes for this. regards, tom lane