Re: How to access tables using a superuser - Mailing list pgsql-general

From John R Pierce
Subject Re: How to access tables using a superuser
Date
Msg-id 4E4CBAB9.8000003@hogranch.com
Whole thread Raw
In response to How to access tables using a superuser  (Siva Palanisamy <siva_p@hcl.com>)
Responses Re: How to access tables using a superuser
List pgsql-general
On 08/17/11 11:58 PM, Siva Palanisamy wrote:
>
> Hi All,
>
> I have few tables being created using an ordinary user account. When I
> login into the postgresql using the super-user, I can’t access my tables!
>
> It says, ERROR: relation "tablename" does not exist.
>
> As I need to perform some operations using super-user, I want the
> tables to be accessed/mapped to the super-user account. Any clue on
> this part?
>
>


are you logged into the same database ? are these tables in a schema
other than public?


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



pgsql-general by date:

Previous
From: Siva Palanisamy
Date:
Subject: How to access tables using a superuser
Next
From: Siva Palanisamy
Date:
Subject: Re: How to access tables using a superuser