On 12/31/13 10:55, peterlen 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?
Use the connect meta without arguments, i.e.
xyz> \c
You are now connected to database "xyz" as user "demo".
or for something 'show' based:
xyz> show session authorization;
session_authorization
-----------------------
demo
(1 row)
HTH,
Bosco.