php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #8317 postgresql table uppercase field name
Submitted: 2000-12-18 20:29 UTC Modified: 2001-05-22 06:47 UTC
From: yamin at 126 dot com Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 4.0.3 OS: redhat 6.2
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2000-12-18 20:29 UTC] yamin at 126 dot com 
Hi:
I use Redhat OS, postgresql database and PHP build my website, I import datas to postgresql, and all the table field name is uppercase like the follwing:

Attribute |    Type     | Modifier
-----------+-------------+----------
 WHFILE    | varchar(10) |
 WHFLDI    | varchar(10) |
 WHFLDE    | varchar(10) |
 WHIBO     | integer     |
 WHFLDB    | integer     |
 WHFLDD    | smallint    |
 WHFLDP    | smallint    |
 WHFTXT    | varchar(50) |
 WHFLDT    | varchar(1)  |
psql query like following can do:
movextest=# select "WHFILE", "WHFLDI","WHFTXT" from cfiffd00 where "WHFILE" like upper('%mpccid%');
but in PHP the query can not run! why? and how to run like this condition?

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-22 06:47 UTC] swm@php.net 
For lack of a script I can only presume that you have not correctly escaped that double quotes meaning that you get either a parse error or, having left them out, get an error from PG because the PG parser converts unquoted table names to lower case.

Any other queries about postgresql and PHP should be addressed to the general lists.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Apr 28 06:01:30 2024 UTC