Skip site navigation (1) Skip section navigation (2)

Re: Select statement error !!!!

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 (view raw or flat)
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 


In response to

pgsql-docs by date

Next:From: Tom LaneDate: 2003-09-24 14:06:30
Subject: Re: Select statement error !!!!
Previous:From: Vutharkar GouthamDate: 2003-09-24 10:27:04
Subject: Select statement error !!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group