Re: some error when executing query in pgAdmin tool

---

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.

Regards, Dave