Re: Lowercase problem
| From: | Dan Wilson | Date: | Mon, 05 Feb 2001 17:36:26 +0000 |
| Subject: | Re: Lowercase problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6401@lists.php.net to get a copy of this message | ||
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
> jcuz@rccd.cc.ca.us