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

Re: case sensitiv table and column names

From: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Re: case sensitiv table and column names
Date: 2000-07-15 20:15:38
Message-ID: 002701bfee99$74b529e0$a65bfea9@dwilson (view raw or flat)
Thread:
Lists: pgsql-php
Just put Kunden  in quotes:

pg_exec($db,"SELECT * FROM \"Kunden\"");

-Dan

----- Original Message ----- 
From: "Matthias Meyer" <m(dot)meyer(at)maxonline(dot)at>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Saturday, July 15, 2000 6:45 AM
Subject: case sensitiv table and column names


> Hallo Mailinglist
> 
> If I use PostgreSQL from PHP3 with pg_exec($db,"SELECT * FROM
> Kunden"); I get an error like "Warning: PostgresSQL query failed: ERROR:
> kunden: Table does not exist."
> Thats right because the table called "Kunden" with an upper K.
> 
> What should I do that PHP/PostgreSQL accept case sensitiv table names ?
> 
> :-)Matthias


In response to

pgsql-php by date

Next:From: dannyDate: 2000-07-27 20:52:36
Subject: how to r/w blob field in postgres
Previous:From: EDWARD POTTERDate: 2000-07-15 17:45:56
Subject: Re: case sensitiv table and column names

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