How to get to know the current user account is superuser or not?

On Mon, Aug 8, 2011 at 10:36 AM, Siva Palanisamy <siva_p@hcl.com> wrote:

I was provided with a user account to access postgresql. I want to process
some high-level operations that might need a superuser/admin privileged
access. How to get to know the user account I was provided having what kind
of privileges? It looks like I don’t have super user account! And I want to
confirm this at the earliest.

The best thing is to spend a few minutes reading the section on
Functions, which details more than 2000 functions designed to help you
with this question and many others.
http://www.postgresql.org/docs/9.1/static/functions.html

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Στις Monday 08 August 2011 12:36:44 ο/η Siva Palanisamy έγραψε:

Hi All,

I was provided with a user account to access postgresql. I want to process some high-level operations that might need a superuser/admin privileged access. How to get to know the user account I was provided having what kind of privileges? It looks like I don't have super user account! And I want to confirm this at the earliest.

SELECT * from pg_user;

Thanks and Regards,
Siva.

________________________________
::DISCLAIMER::
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------

--
Achilleas Mantzios

Hi Achilleas,

Thanks a lot for your reply. I got what I wanted now! I knew this question was very basic but I am completely new to PostgreSQL..!!

Thanks and Regards,
Siva.

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Achilleas Mantzios
Sent: Monday, August 08, 2011 4:01 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get to know the current user account is superuser or not?

Στις Monday 08 August 2011 12:36:44 ο/η Siva Palanisamy έγραψε:

Hi All,

I was provided with a user account to access postgresql. I want to process some high-level operations that might need a superuser/admin privileged access. How to get to know the user account I was provided having what kind of privileges? It looks like I don't have super user account! And I want to confirm this at the earliest.

SELECT * from pg_user;

Thanks and Regards,
Siva.

________________________________
::DISCLAIMER::
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------

--
Achilleas Mantzios

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Hi All,

I was provided with a user account to access postgresql. I want to process
some high-level operations that might need a superuser/admin privileged
access. How to get to know the user account I was provided having what kind
of privileges? It looks like I don't have super user account! And I want to
confirm this at the earliest.

Thanks and Regards,

Siva.

Ask the person who setup your user.