Hot answers tagged postgresql
Your data looks like it's Mercator (big negative X's). I'll assume web mercator, but that could be wrong, and may lead to meter-level inaccuracies (if it's "real" mercator, use 3395). shp2pgsql -c -d -D -W LATIN1 -s 3857 -I 'path/to/shapefile.shp' my_table | psql -d mydb Now flip the coordinates to geographics inside the database ALTER TABLE my_table ...
From What I have found I think we can simply parse the xsd and find the column names.Since the column names are in any case going to be in string format.We only need to store that as varchar in the postgres table.
Only top voted, non community-wiki answers of a minimum length are eligible