Thanks Nicolas, for the reminder on that. On Dec 27, 2012 3:58 AM, "Nicolas Ribot" <[email protected]> wrote:
> 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 <[email protected]> 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 >> [email protected] >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
