[Mapserver-users] Accessing uppercase tables with a PostGIS connection

[David Blasby]

Jeff McKenna wrote:

> yes i wrote that wrong..i meant a column name, sorry.  The column name 
> is ""CST00SRF" .  I want to avoid having to reload all of the data (with 
> the LAUNDER option).  Is that my only option?

You can try using quotes around your column name in the DATA statement.

Otherwise, you can do this:

ALTER TABLE <table> RENAME COLUMN "CST00SRF" TO cst00srf;

dave