Looking for help
Looking for help
От:
Joseph L Montes <jmontes@zenplex.com>
Дата:
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
Re: Looking for help
От:
"Patrick Hatcher" <PHatcher@macys.com>
Дата:
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
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
Re: Looking for help
От:
"Cornelia Boenigk" <poppcorn@cornelia-boenigk.de>
Дата:
Hi Joseph > but What happens > if I only want to select a couple of fields. Then you tell the server which fields you want to select;-) SELECT field1, field2, ... , fieldn FROM table ... > how do you select from a table that is not all lower case what do you mean? what is not all lower case? PostgreSQL returns the contents of the fields as they are. If you need the results to be in lower case use SELECT lower(fieldx), lower(field2),... FROM table respectively SELECT upper(field1), upper(field2), ... FROM table. See chapter 4.4 of the PostgreSQL user's Guide for more. The PHP-Functions to change case are strtoupper() and strtolower(). Hope it helps Regards Conni
Re: Looking for help
От:
Papp Gyozo <pgerzson@freestart.hu>
Дата:
2002. augusztus 28. 01:05 dátummal Patrick Hatcher ezt írta: > 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' "); > AFAIK, opstgres needs double quotes to handle objects' names literally -- as written: $result = pg_query($db,' Select "Field1",field2, "fiEld3" From "TABLE1"'); text within simple quotes represents string literals. -- Papp, Győző - pgerzson@freestart.hu
Re: Looking for help
От:
Keary Suska <hierophant@pcisys.net>
Дата:
on 8/27/02 4:56 PM, jmontes@zenplex.com purportedly said: > 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 Table and column names are not case-sensitive in Postgres. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"