Case sensitive table names ?

Started by Per Winkvistabout 24 years ago2 messagesbugs
Jump to latest
#1Per Winkvist
nd96pwt@adeptus.student.hig.se

Hi,

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,

Per

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Per Winkvist (#1)
Re: Case sensitive table names ?

Per Winkvist writes:

When creating a table from psql named 'tblProduct' that is turned into
tblproduct.

Unless you double-quote it.

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 ?

No.

--
Peter Eisentraut peter_e@gmx.net