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. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general