[postgis-users] Import question

Eric Aspengren ericaspen at gmail.com
Thu Dec 27 06:15:05 PST 2012


Thanks Nicolas, for the reminder on that.
On Dec 27, 2012 3:58 AM, "Nicolas Ribot" <nicolas.ribot at gmail.com> 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 <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
>>
>>
>
> _______________________________________________
> 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/ef6536d8/attachment.html>


More information about the postgis-users mailing list