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\"";
-Dan
> 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
> [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]