On Thu, 2011-08-18 at 12:48 +0530, Siva Palanisamy wrote:
> Hi John,
>
> I logged into the same database. I can say the commands, and you can correct
> me if I'm wrong.
>
> Ordinary User: psql -h localhost -d db -U ordinaryusername
> Select * from contacts
> Now, I can access the tables. I also
user.
Thanks and Regards,
Siva.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Thursday, August 18, 2011 12:40 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to access tables using a
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 usi
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/
