> > \copy "Flight Traffic" from yourfile.csv delimiter as ',' > csv quote as > > '"' > > > > (might need some adaption, of course) > > > > > > Loading 45,000 lines is trivial for copy, it shouldn't take > noticable > > time at all. > ---- > along these lines - can I do something similar (CSV file) but > 'update' 2 or 3 columns? I'd use COPY to a temp table, then run a normal UPDATE on that. //Magnus
