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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Siva Palanisamy <siva_p(at)hcl(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get to know the current user account is superuser or not?
Date: 2011-08-08 09:56:06
Message-ID: CA+U5nMLry0zruwuuV9TJHQm-dPBcBhyLW2vJ8QbUfUzXrqD_Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 8, 2011 at 10:36 AM, Siva Palanisamy <siva_p(at)hcl(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2011-08-08 10:02:20 Re: Backup & Restore a database in PostgreSQL
Previous Message Siva Palanisamy 2011-08-08 09:36:44 How to get to know the current user account is superuser or not?