[postgis-users] Import question

[Nicolas Ribot]

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.

Nicolas


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>