beOpen
 

pgloader is a usefull program for load into postgresql data in varius format (don’t confuse with the loader for postgis). It currently requires Tcl.

Installation

Then on debian SID you can do simply this:

apt-get install tcllib libpgtcl
wget http://pgfoundry.org/frs/download.php/233/pgloader-1.0.tar.gz
tar zxvf pgloader-1.0.tar.gz

Use

  1. You need to prepare the table in postgresql (all columns name in locase)
  2. prepare a file with config as in README (all columns name in locase)
  3. load data with something

./pgloader Comuni_Lombardia.conf Comuni_Lombardia.csv “host=localhost user=gis password=pass dbname=geocap”

 
postgresql/pgloader.txt · Ultima modifica: 13/08/2006 23:42
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki