| 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 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| 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 | Content-Type | Size | 
|---|---|---|
| force_quote_all-20090512.patch | application/octet-stream | 4.5 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Khee Chin | 2009-05-12 05:36:20 | Re: Show method of index | 
| Previous Message | Khee Chin | 2009-05-12 04:41:05 | Re: Show method of index |