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