Use quotes around the field and table names that are not all lower case:
Ex:
$result = pg_query($db," Select 'Field1',field2, 'fEild3' From'TABLE1' ");
Patrick Hatcher
Joseph L Montes
<jmontes@zenplex.com To: pgsql-php@postgresql.org
> cc:
Sent by: Subject: [PHP] Looking for help
pgsql-php-owner@post
gresql.org
08/27/2002 03:56 PM
I am new to combining PHP and Postgres. I am able to Select and create
tables by using the Select * From "table" command fine, but What happens
if I only want to select a couple of fields. How do I go about this.
also how do you select from a table that is not all lower case. Granted
this is probably quite simple, but I am new to this. thanks ewveryone
--
Joseph L Montes
Senior Systems Engineer
Zenplex Inc.
317 Madison Ave. suite 1500
New York New York
V(212)499-0668 Ext. 203
F(646)865-0783
http://www.zenplex.com
http://www.zenplex.org
http://www.tambora.org
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html