You need to put quotes around the upper- or mixed-case table names.

SELECT * FROM "MixedCase"

Of course within PHP, you need to escape those quotes:

$query = "SELECT * FROM \"MixedCase\"";


> Hi--
> I don't know where the problem resides, but when I call a table or a field
> name from Postgresql using PHP4, it treats the string ALL LOWERCASE, so I
> get an error about 'field/table not relational..." do you know where the
> problem is?
> P.S.  Some tables have upper and lowercase, as well as field names...I had
> to transfer everything to lowercase to get it working.
> Julio Cuz, Jr.
> Riverside Community College

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to