On Tue, Dec 31, 2013 at 10:55 AM, peterlen <peteralen@xxxxxxxxxxxxx> wrote:
After logging into the PSQL Shell Script as a particular user and database, I
want to display who my current user is and what database I am in as I may
have forgotten who I am logged in as in order to make sure any commands are
going to the right place. In Oracle's SQLPlus you can do something like
"show user" and get feedback on the user you are logged in as. Is there an
equivalent thing for PSQL to list the user and database?
Thanks - Peter
As Adrian Klaver mentioned, you can set your psql prompt. Here are few entries from my $HOME/.psqlrc
\set PROMPT1 '%n@%`hostname`:%> [%/] %x%# '
\timing on
\pset pager off
\x auto
\set HISTCONTROL = ignoreboth
\set PROMPT1 '%n@%`hostname`:%> [%/] %x%# '
\timing on
\pset pager off
\x auto
\set HISTCONTROL = ignoreboth
