Thread: How to list current user and database in PSQL
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.
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
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.
On 12/31/13 11:06, Bosco Rama wrote: > > Use the connect meta without arguments, i.e. > > xyz> \c > You are now connected to database "xyz" as user "demo". Hmmm. Scratch that. That actually does a reconnect. Probably not what you want, especially is you are in the middle of a transaction. :-( Bosco.
Excellent. That works. Many thanks! -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-list-current-user-and-database-in-PSQL-tp5784928p5784932.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Tue, Dec 31, 2013 at 10:55 AM, peterlen <peteralen@earthlink.net> 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?
Thanks - Peter
As Adrian Klaver mentioned, you can set your psql prompt. Here are few entries from my $HOME/.psqlrc
\set PROMPT1 '%n@%`hostname`:%> [%/] %x%# '
\timing on
\pset pager off
\x auto
\set HISTCONTROL = ignoreboth
\set PROMPT1 '%n@%`hostname`:%> [%/] %x%# '
\timing on
\pset pager off
\x auto
\set HISTCONTROL = ignoreboth