for psql and from the perl interface,
the correct syntax seems to be:
select "field" from "table" where "field"='value';
... with the single quotes to be protected with \ when
the request is sent to the backend from a script
(rather than psql);
Peter Mount wrote:
> Unless the field names are in quotes, the parser forces them into
> lowercase, so in your example, you would change it to:
> select 'Name' from 'Services';
> > I've a problem with uppercase letter in table and fields definition.
> > For example let be a table called 'Services' with fields 'Id' 'Name'
> > 'Vaule', now if with PHP or pgaccess ort psql I make this query:
> > SELECT Name FROM Services;
> > I got this:
> > ERROR: attribute 'name' not found.
> > what is wrong with my configuration?
> > ciao,
> > Fabio.
> > ************
Software Engineer - Network Engineering
Global Media Corporation
phone: 888.322.2282 - http://www.globalmediacorp.com
In response to
pgsql-interfaces by date
|Next:||From: Patrick Welche||Date: 1999-10-29 16:43:07|
|Subject: ODBC driver|
|Previous:||From: SAKAIDA||Date: 1999-10-29 10:37:23|
|Subject: pgbash-1.2.1 released|