On 01/31/2013 10:17 AM, Rich Shepard wrote:
> On Thu, 31 Jan 2013, Adrian Klaver wrote:
>
>> FORCE_QUOTE Forces quoting to be used for all non-NULL values in each
>> specified column. NULL output is never quoted. If * is specified,
>> non-NULL values will be quoted in all columns. This option is allowed
>> only
>> in COPY TO, and only when using CSV format.
>
>> Use FORCE_QUOTE * to quote all columns.
>
> Adrian,
>
> That's correct. Most of the columns are numeric so each text column
> needs
> to be specified.
Any particular reason why?
>
> Thanks,
>
> Rich
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com