Re: Identify Login User & Permissions

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identify Login User & Permissions
Date: 2010-09-14 20:23:48
Message-ID: 4C8FD9D4.6080308@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 14/09/2010 22:01, Carlos Mennens a écrit :
> I can't find in the docs or using Google how one can identify which
> user is currently logged in to psql. I search for the command that if
> for some reason I forget which user I am logged in as, rather than
> logging out of PostgreSQL, there has to be a command that shows me who
> I am and also what kind of special permissions my current user has.
> Can anyone please assist me or point me in the right direction?
>

SELECT current_user;

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Brinkman 2010-09-14 20:27:25 Re: I keep getting "type does not exist" on compile of this SETOF function (list 2 table)
Previous Message Carlos Mennens 2010-09-14 20:01:05 Identify Login User & Permissions