Skip site navigation (1) Skip section navigation (2)

Case sensitive table names ?

From: Per Winkvist <nd96pwt(at)adeptus(dot)student(dot)hig(dot)se>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Case sensitive table names ?
Date: 2002-03-13 20:10:03
Message-ID: Pine.GSO.4.21.0203132108330.28812-100000@spartacus (view raw or whole thread)
Lists: pgsql-bugs
(Dunno if my previous got sent or not since I wasn't subscribed)


When creating a table from psql named 'tblProduct' that is turned into
tblproduct. (I'm accessing pg through Qt db classes too and I experience
the same thing there too I believe)

However, when creating a table with the tcl/tk application pgaccess you
can create a table that have capital letters. Isn't this a bug ?

Would be nice if one could create tables as tBlPrOdUcT and they appear
that way when querying system tables but also be able to access it non
case sensitive through sql.

Great job guys,


pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-03-13 20:31:25
Subject: Re: referential constraint bug
Previous:From: Tom LaneDate: 2002-03-13 19:39:37
Subject: Re: Bug #613: Sequence values fall back to previously checkpointed

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group