This is standard, documented behaviour. No way we can change that. Is
there a reason why your front-end tools cannot compare the names
case-insensitively?
On Mon, 17 Jan 2000, Hakan Tandogan wrote:
>
> Hi,
>
> I'm sending this to -hackers instead of -users because I think I'm
> asking for a new feature in psql.
>
> My Problem: If I run a sql file with create-table-statements through
> psql, all the column names get automagically lowercased. On the other hand, the
> Object-Relational-Mapping tool I'm using recreates all its objects from a
> ResultSet, getting the lowercase names, and compares them with uppercase ones,
> thus failing silently.
>
> I'm working around this issue by enclosing the column names in ",
> leading to slightly ugly ddl files (create table USERROLE ("ROLEID" serial
> PRIMARY KEY, "PERMISSION" varchar);) and the necessity to change the default
> data files (enclosing column names in insert statements with ").
>
> Would it be possible to add a flag to psql, telling it to accept the
> column names as they are in the ddl file?
>
>
> Regards,
> Hakan
>
>
>
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden