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

Re: [INTERFACES] Uppercase problem with several interfaces

From: Sebastien Flacher <sflacher(at)globalmedia(dot)com>
To:
Cc: Psql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Uppercase problem with several interfaces
Date: 1999-10-29 16:12:34
Message-ID: 3819C772.A6DCD281@globalmedia.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello everybody,

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.
> >
> >
> > ************
> 
> ************

-- 
Sebastien Flacher
Software Engineer - Network Engineering
sflacher(at)globalmedia(dot)com

Global Media Corporation
phone: 888.322.2282 - http://www.globalmediacorp.com

In response to

pgsql-interfaces by date

Next:From: Patrick WelcheDate: 1999-10-29 16:43:07
Subject: ODBC driver
Previous:From: SAKAIDADate: 1999-10-29 10:37:23
Subject: pgbash-1.2.1 released

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