Postgres Pro
Downloads
Home   >   mailing lists

How to list current user and database in PSQL - Mailing list pgsql-general

From peterlen
Subject How to list current user and database in PSQL
Date
Msg-id 1388516150796-5784928.post@n5.nabble.com
Whole thread Raw
Responses Re: How to list current user and database in PSQL  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: How to list current user and database in PSQL  (Bosco Rama <postgres@boscorama.com>)
Re: How to list current user and database in PSQL  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Announce: Cyan Audit: Forensic audit logging for PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: How to list current user and database in PSQL