[postgis-users] Import question

Nicolas Ribot nicolas.ribot at gmail.com
Thu Dec 27 01:58:17 PST 2012

Hi Eric,

You can use OGR (ogr2ogr, http://www.gdal.org/ogr/drv_csv.html) to achieve
that: table will be created based on headers.
A script would allow you to load all the files automatically.

WKT geometries can also be imported in text format (then later converted to
actual geometries).
Look at the format restrictions like data types.


On 27 December 2012 00:43, Eric Aspengren <ericaspen at gmail.com> wrote:

> This is probably a very simple question:
> I've got a large number of tables to be loaded into a postgis database.
> They are all csv. They all have headers that are unique to each table.
> Rather than create each table, individually, is there a way of creating a
> table from the headers and inserting the data, in bulk?
> --
> Eric Aspengren
> (402) 478-8683
> www.streetlevelstrategies.com
> ericaspen at gmail.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121227/270a707b/attachment.html>

More information about the postgis-users mailing list