[postgis-users] shp2pgsql & uppercase tablenames

[Jeff Lounsbury]

shp2pgsql inserts all tables and column names as lower case because Postgresql
interprets everything as lower case unles you force it to be upper cased by
quoting your table name and column names. This is done on purpose so that case is
not accidentally causing people to become very confused about how to reference
the table and column names that have upper case in them.

Were you having any problems other than all things being lower cased? You said
you were getting actual errors? Let me know if this is the case...
-Jeff
Refractions Research

Vincent Schut wrote:

> If you try to add some shape to postgres using the shp2pgsql utility, and you
> specify a tablename that contains uppercase characters, errors occur. Is this
> a bug or is it a feature? It seems to me that shp2pgsql shows no consistent
> behaviour regarding uppercase characters in tablenames, but I might be wrong
> and it might be intended behaviour...
>
> Cheers,
> --
> ______________________________________
> Vincent Schut (schut at sarvision.com)
> Sarvision B.V.
> Wageningen, The Netherlands
> www.sarvision.com
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users