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
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: yamin at 126 dot com
New email:
PHP Version: OS:

 

 [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: Sat Apr 27 19:01:29 2024 UTC