[Live-demo] What data should be included on the LiveDVD & Postgres installer

Hamish hamish_b at yahoo.com
Wed Sep 16 03:24:55 EDT 2009


Alex Mandel wrote:
> Just need someone with the sample data to import it into Postgres and
> then do some SQL dumps. These .sql files can then be run on the command
> line with psql and would build and populate the tables.
> 
> That's the safe way to do it since importing from shp and other formats
> may be more likely to an error that needs human intervention.


for those of us who don't know PostgreSQL very well but are pretty good at
monkey-see monkey-do, a command by command example of how to do this on
the wiki would be incredibly helpful. it doesn't have to be anything fancy.

e.g., starting with shp2pgsql, then export to the .sql, and finally reimporting back into the destination PostGIS db.


thanks,
Hamish



      



More information about the Live-demo mailing list