Re: Lowercase problem

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-php(at)postgresql(dot)org>, <php-db(at)lists(dot)php(dot)net>, "Julio Cuz, Jr(dot)" <jcuz(at)rccd(dot)cc(dot)ca(dot)us>
Subject: Re: Lowercase problem
Date: 2001-02-05 17:37:29
Message-ID: 011001c08f9a$5065d380$0200000a@windows
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-php

Try quoting your table names.

SELECT * FROM "WHATEVER";

-Mitch

----- Original Message -----
From: "Julio Cuz, Jr." <jcuz(at)rccd(dot)cc(dot)ca(dot)us>
To: <pgsql-php(at)postgresql(dot)org>; <php-db(at)lists(dot)php(dot)net>
Sent: Monday, February 05, 2001 12:25 PM
Subject: [PHP] Lowercase problem

> 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(at)rccd(dot)cc(dot)ca(dot)us
>
>

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Mitch Vincent 2001-02-05 18:02:02 Crazy PHP-> PostgreSQL errors
Previous Message Julio Cuz, Jr. 2001-02-05 17:25:11 Lowercase problem