On 2013-01-31, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote: > I'd like to understand what I'm missing when I COPY a table to a .csv file > but the text is not quoted. > > Here's an example of a command: > > copy chemistry to '/home/postgres/emapchem.csv' with (format CSV, header True, quote '"', delimiter '|'); > > and here're part of the header and following row of the output: > > siteid|sampdate|analdate|ph|cond|turb|tss|doc|dic|p|se|ca|mg|na|k|nh4|so4|no3 > 1993SBOIA049|2004-06-28|2004-06-28|7.67|117|4.21|6.1|1.13|11.96|40|0.2|503.5|206.2 > > I'm sure it's something simple in the syntax I keep getting wrong, but I > don't see it. Quotes are optional in csv except for strings containg linebreaks, quotes, or delimiters where they are required. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
