From: Penchalaiah P. [mailto:penchalaiahp@infics.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.
