Re: case sensitiv table and column names - Mailing list pgsql-php

From EDWARD POTTER
Subject Re: case sensitiv table and column names
Date
Msg-id 3970A354.16F3212A@prodigy.net
Whole thread Raw
In response to case sensitiv table and column names  (Matthias Meyer <m.meyer@maxonline.at>)
List pgsql-php
Is there any reason why u can't use kunden?

I guess since PHP is open source [and so is Postgres] u could probably hack
that code on your own to accept either upper or lower case names.

On the other hand,  maybe there is a simpler solution, but I have not yet
stumbled on it...

!ed


> 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

Attachment

pgsql-php by date:

Previous
From: Matthias Meyer
Date:
Subject: case sensitiv table and column names
Next
From: "Dan Wilson"
Date:
Subject: Re: case sensitiv table and column names