COPY table to file missing quotation marks
От
Rich Shepard
Тема
COPY table to file missing quotation marks
Дата
Msg-id
alpine.LNX.2.00.1301310832030.32615@salmo.appl-ecosys.com
Список
Дерево обсуждения
Re: COPY table to file missing quotation marks Jasen Betts <jasen@xnet.co.nz>
Re: COPY table to file missing quotation marks Vick Khera <vivek@khera.org>
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
В списке pgsql-general по дате отправления