<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

Fri, 24 Nov 2000 12:05:04 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 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

Fri, 24 Nov 2000 18:45:48 +0100 (CET)
<pejac@altern.org>
Bug with CREATE TABLE .....