Opened 20 years ago

Closed 17 years ago

#524 closed enhancement (fixed)

Uppercase table names in ogr2ogr PostgreSQL driver

Reported by: sfrost@… Owned by: warmerdam
Priority: normal Milestone:
Component: OGR_SRS Version: unspecified
Severity: minor Keywords:
Cc:

Description (last modified by warmerdam)

It is possible to have mixed-case table names in PostgreSQL but in general they get annoying to deal with. The reason for this is because all the clients talking to the database must explicitly double-quote the table name. It's much nicer if everyone just does the same thing psql does- use lowercase table/column names by default.

Change History (2)

comment:1 by warmerdam, 20 years ago

Stephen, 

There is already a layer creation option, LAUNDER=YES, that will convert
field and tables to lower case if enabled.  Arguably YES should be the default
and users should set it to NO to preserve their original name case.  

I think I will make that change. 


comment:3 by warmerdam, 17 years ago

Description: modified (diff)
Priority: highnormal
Resolution: fixed
Status: assignedclosed

Closing as the requirement is satisfied. I'm not sure why it is still open.

Note: See TracTickets for help on using tickets.