Re: some error when executing query in pgAdmin tool

________________________________

From: Penchalaiah P. [mailto:penchalaiahp(at)infics(dot)com]
Sent: 23 May 2006 13:18
To: Dave Page
Subject: RE: [SQL] some error when executing query in pgAdmin
tool

Hi sir...

I tried like that also ... but I am getting same error......I
tried like these......

1).Select * from adv;

2). Select * from "adv";

3).Select * from public.adv; here public is the schema name

Like I said, try:

SELECT * FROM "ADV";

You created the table with a quoted, uppercase name, so that is how you
must reference it.

Regards, Dave