[postgis-users] loading data

[Gregory S. Williamson]

Copy works like a champ for spatial data, as far as our experience goes. As long as column order and NULL assignments agree, copying from file to table is no problem.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:	Wood Brent [mailto:pcreso at pcreso.com]
Sent:	Thu 4/15/2004 10:20 AM
To:	PostGIS Users Discussion
Cc:	
Subject:	[postgis-users] loading  data

Hopefully a simple query.

I've been using copy as my bulk loader for postgres.

copy isn't mentioned as working or not for tables with a postgis geometry
column in the PostGIS docs so I fgured I'd ask here.

Does copy work? 
If so, is there any special format for the geometry data?
If I can copy from a table to file, will it work the other way (with the same  
 format)?

(I know I could try this, but I figure it may appear to work but not, & there
may be gotchas or caveats, so asking the experts for advice is safer :-)


Thanks,

  Brent Wood
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users