> > \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