From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Vutharkar Goutham <goutham4u(at)hotmail(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Select statement error !!!! |
Date: | 2003-09-24 11:00:49 |
Message-ID: | 1064401249.6612.82.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Wed, 2003-09-24 at 11:27, Vutharkar Goutham wrote:
> Hello,
>
> I am doing a simple program with PostgreSql wherein i am giving a select
> statement as an argument to PQexec like this
>
>
> char query[1024];
> strcpy(query,"Select * from Udp_Table");
> now if i try to execute the above statement it is giving me always teh
> select failed message.
In that statement you have a mixed case name for the table. If it has a
mixed case name in the database too, the name needs to be enclosed in
double quotes.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And we know that all things work together for good to
them that love God, to them who are the called
according to his purpose."
Romans 8:28
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-24 14:06:30 | Re: Select statement error !!!! |
Previous Message | Vutharkar Goutham | 2003-09-24 10:27:04 | Select statement error !!!! |