From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: some error when executing query in pgAdmin tool |
Date: | 2006-05-23 12:10:38 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40138843A@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
________________________________
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
From | Date | Subject | |
---|---|---|---|
Next Message | Penchalaiah P. | 2006-05-23 12:10:46 | some error when executing query in pgAdmin tool |
Previous Message | Dave Page | 2006-05-23 12:06:12 | Re: some error when executing query in pgAdmin tool |