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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
