Subject: Re: Select statement error !!!!
From: Oliver Elphick <olly@lfix.co.uk>
To: Vutharkar Goutham <goutham4u@hotmail.com>
Cc: pgsql-docs@postgresql.org
In-Reply-To: <Sea1-F17prhMOgRGkQ600000446@hotmail.com>
References: <Sea1-F17prhMOgRGkQ600000446@hotmail.com>
Content-Type: text/plain
Organization: LFIX Limited
Message-Id: <1064401249.6612.82.camel@linda.lfix.co.uk>
Mime-Version: 1.0
Date: Wed, 24 Sep 2003 12:00:49 +0100
Content-Transfer-Encoding: 7bit

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.Elphick@lfix.co.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