How to list current user and database in PSQL

From: peterlen <peteralen(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: How to list current user and database in PSQL
Date: 2013-12-31 18:55:50
Message-ID: 1388516150796-5784928.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-list-current-user-and-database-in-PSQL-tp5784928.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-12-31 19:06:32 Re: How to list current user and database in PSQL
Previous Message Moshe Jacobson 2013-12-31 18:09:40 Announce: Cyan Audit: Forensic audit logging for PostgreSQL