[postgis-users] loading data

[Gerry Creager N5JXS]

What do you do if there are duplicates?  How're you handling dupes/indices?

gerry

Gregory S. Williamson wrote:
> 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
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Gerry Creager -- gerry.creager at tamu.edu
Network Engineering -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843