Thread: Bug with CREATE TABLE .....

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

<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