On 12/31/2013 10:55 AM, 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?
test=> select current_user;
current_user
--------------
aklaver
(1 row)
test=> select current_database();
current_database
------------------
test
Or you can change the psql prompt to display the information:
http://www.postgresql.org/docs/9.3/interactive/app-psql.html
Search for:
"Prompting"
Details the variables available
"Files"
Explains how to persist this information in a psqlrc file.
>
> 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.
>
>
--
Adrian Klaver
adrian.klaver@gmail.com