Skip site navigation (1) Skip section navigation (2)

COPY WITH CSV FORCE QUOTE *

From: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: COPY WITH CSV FORCE QUOTE *
Date: 2009-05-12 04:49:14
Message-ID: 20090512131316.9514.52131E4D@oss.ntt.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

FORCE QUOTE option of COPY WITH CSV requires an explicit column list,
but '*' (all columns) would be also useful for typical usages.

I searched the ML archive and found one request before:
| COPY TO with FORCE QUOTE *
| http://archives.postgresql.org/pgsql-sql/2008-08/msg00084.php

The attached is a WIP patch add a support of '*' for FORCE QUOTE
and FORCE NOT NULL options. I'd like to submit it for the next
commit fest (8.5). Comments welcome.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

Attachment: force_quote_all-20090512.patch
Description: application/octet-stream (4.5 KB)

Responses

pgsql-hackers by date

Next:From: Khee ChinDate: 2009-05-12 05:36:20
Subject: Re: Show method of index
Previous:From: Khee ChinDate: 2009-05-12 04:41:05
Subject: Re: Show method of index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group