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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
