Re: Plan for CSV handling of quotes, NULL

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