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: (view raw, whole thread or download thread mbox)
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                   
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-2017 The PostgreSQL Global Development Group