Re: [SQL] some error when executing query in pgAdmin tool

[Dave Page]

From: Penchalaiah P. [mailto:[EMAIL PROTECTED] 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