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
