COPY table to file missing quotation marks

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY table to file missing quotation marks
Date: 2013-01-31 16:37:35
Message-ID: alpine.LNX.2.00.1301310832030.32615@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-01-31 16:46:25 Re: COPY table to file missing quotation marks
Previous Message Glus Xof 2013-01-31 16:25:53 SQL sentence to insert where updated rows is zero...