Ticket #524 (closed enhancement: fixed)

Opened 9 years ago

Last modified 6 years ago

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) (diff)

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

Changed 9 years ago by warmerdam 

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.

Changed 6 years ago by warmerdam

  • priority changed from high to normal
  • status changed from assigned to closed
  • resolution set to fixed
  • description modified (diff)

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

Note: See TracTickets for help on using tickets.