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. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend