Andrew Dunstan wrote:
> Bruce Momjian said:
> > Andrew Dunstan wrote:
> >>
> >> copy mytable to 'mydata.csv' csv force zipcode;
> >>
> >> seems OK to me. I'm all in favor of low-tecH solutions where
> >> appropriate. ;-)
> >
> > Could we have FORCE just force quotes on all values, rather than
> > allowing a list of columns to be specified? Seems if you have a
> > strange zipcode field, it would be easier to just do them all.
> >
>
> Then dates and numbers would be wrong. No all or nothing switch will work.
OK, I will start coding. So FORCE col1, col2 will force quotes on those
two columns, right?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073