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

Re: a question, please help me.

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: wu xiao <zolawu(at)hotmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: a question, please help me.
Date: 2005-07-20 23:51:00
Message-ID: 42DEE364.20801@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
wu xiao wrote:

> PreparedStatement ps = db.prepareStatement("select * from operator where
> ID=?");

> The sqlexception is:....column 'id' is not exist..... What's the reason
> please? All of the tables are created in Windows XP.

If you've created the table with a capitalized column name, you will
need to quote it in your SQL:

  "select * from operator where \"ID\"=?"

Unquoted identifiers (column names, table names, etc) are forced to
lowercase by the server.

-O

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-07-20 23:57:29
Subject: Re: Timestamp Conversion Woes Redux
Previous:From: Tom LaneDate: 2005-07-20 23:47:12
Subject: Re: Timestamp Conversion Woes Redux

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