pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedcase sensitiv table and column names
3+ messages / 3 participants
[nested] [flat]
* case sensitiv table and column names
@ 2000-07-15 12:45 Matthias Meyer <m.meyer@maxonline.at>
2000-07-15 17:45 ` Re: case sensitiv table and column names EDWARD POTTER <ejpusa@prodigy.net>
2000-07-15 20:15 ` Re: case sensitiv table and column names Dan Wilson <phpPgAdmin@acucore.com>
0 siblings, 2 replies; 3+ messages in thread
From: Matthias Meyer @ 2000-07-15 12:45 UTC (permalink / raw)
To: pgsql-php
Hallo Mailinglist
If I use PostgreSQL from PHP3 with pg_exec($db,"SELECT * FROM
Kunden"); I get an error like "Warning: PostgresSQL query failed: ERROR:
kunden: Table does not exist."
Thats right because the table called "Kunden" with an upper K.
What should I do that PHP/PostgreSQL accept case sensitiv table names ?
:-)Matthias
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: case sensitiv table and column names
2000-07-15 12:45 case sensitiv table and column names Matthias Meyer <m.meyer@maxonline.at>
@ 2000-07-15 17:45 ` EDWARD POTTER <ejpusa@prodigy.net>
1 sibling, 0 replies; 3+ messages in thread
From: EDWARD POTTER @ 2000-07-15 17:45 UTC (permalink / raw)
To: Matthias Meyer <m.meyer@maxonline.at>; +Cc: pgsql-php
Is there any reason why u can't use kunden?
I guess since PHP is open source [and so is Postgres] u could probably hack
that code on your own to accept either upper or lower case names.
On the other hand, maybe there is a simpler solution, but I have not yet
stumbled on it...
!ed
> Hallo Mailinglist
>
> If I use PostgreSQL from PHP3 with pg_exec($db,"SELECT * FROM
> Kunden"); I get an error like "Warning: PostgresSQL query failed: ERROR:
> kunden: Table does not exist."
> Thats right because the table called "Kunden" with an upper K.
>
> What should I do that PHP/PostgreSQL accept case sensitiv table names ?
>
> :-)Matthias
Attachments:
ejpusa.vcf (text/x-vcard, 127B) download
begin:vcard
n:Potter;Edward
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:ejp@well.com
fn:Edward Potter
end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: case sensitiv table and column names
2000-07-15 12:45 case sensitiv table and column names Matthias Meyer <m.meyer@maxonline.at>
@ 2000-07-15 20:15 ` Dan Wilson <phpPgAdmin@acucore.com>
1 sibling, 0 replies; 3+ messages in thread
From: Dan Wilson @ 2000-07-15 20:15 UTC (permalink / raw)
To: pgsql-php
Just put Kunden in quotes:
pg_exec($db,"SELECT * FROM \"Kunden\"");
-Dan
----- Original Message -----
From: "Matthias Meyer" <m.meyer@maxonline.at>
To: <pgsql-php@postgresql.org>
Sent: Saturday, July 15, 2000 6:45 AM
Subject: case sensitiv table and column names
> Hallo Mailinglist
>
> If I use PostgreSQL from PHP3 with pg_exec($db,"SELECT * FROM
> Kunden"); I get an error like "Warning: PostgresSQL query failed: ERROR:
> kunden: Table does not exist."
> Thats right because the table called "Kunden" with an upper K.
>
> What should I do that PHP/PostgreSQL accept case sensitiv table names ?
>
> :-)Matthias
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-07-15 20:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-15 12:45 case sensitiv table and column names Matthias Meyer <m.meyer@maxonline.at>
2000-07-15 17:45 ` EDWARD POTTER <ejpusa@prodigy.net>
2000-07-15 20:15 ` Dan Wilson <phpPgAdmin@acucore.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox