| From: | Surafel Temesgen <surafel3000(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | COPY FROM WHEN condition |
| Date: | 2018-10-11 08:54:55 |
| Message-ID: | CALAY4q_DdpWDuB5-Zyi-oTtO2uSk8pmy+dupiRe3AvAc++1imA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
Currently we can not moves data from a file to a table based on some
condition on a certain column but I think there are many use case for it
that worth supporting. Attache is a patch for escaping a row that does not
satisfy WHEN condition from inserting into a table and its work on the top
of commit b68ff3ea672c06
and the syntax is
COPY table_name [ ( column_name [, ...] ) ]
FROM { 'filename' | PROGRAM 'command' | STDIN }
[ [ WITH ] ( option [, ...] ) ]
[ WHEN condition ]
comment ?
Regards
Surafel
| Attachment | Content-Type | Size |
|---|---|---|
| copy_from_when_con_v1.patch | text/x-patch | 8.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Moench-Tegeder | 2018-10-11 08:59:25 | Re: COPY FROM WHEN condition |
| Previous Message | Kyotaro HORIGUCHI | 2018-10-11 08:04:53 | Re: [HACKERS] WAL logging problem in 9.4.3? |