Bug with CREATE TABLE .....

Started by Nonamealmost 26 years ago2 messageshackers
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#2)
Re: Bug with CREATE TABLE .....

<pejac@altern.org> writes:

Strnage isn't it????

No. That's the intended and documented behavior. See the manual, eg,
http://www.postgresql.org/users-lounge/docs/7.0/postgres/syntax525.htm

regards, tom lane

#2Noname
pejac@altern.org

Hi,

First excuse me for my bad english,

I use postgresql V7.0.2 with linux and I found a stange
result with create table.

CREATE TABLE "UTILISATEURS" (
..
);

Ok no problem, and when i use \\dt under pgsql i see this
name. But when i write select * from UTILISATEURS ,it doesn't
work. if i create table a second table
CREATE TABLE "utilistaeurs" (
...
);
and if i write select * from UTILISATEURS it works but postgresql
refer to table "utilisateurs". And if i tape
select * from "UTILISATEURS" it's work and refer to
table UTILISATEURS

Strnage isn't it????

Thanks,

Best regards