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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-php by date

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