Re: COPY FROM WHEN condition

Corey Huinker <corey.huinker@gmail.com>

From: Corey Huinker <corey.huinker@gmail.com>

To: david@fetter.org

Cc: nasbyj@amazon.com, surafel3000@gmail.com, cmt@burggraben.net, pgsql-hackers@lists.postgresql.org

Date: 2018-11-03T02:53:05Z

Lists: pgsql-hackers

>
>
> > SELECT x.a, sum(x.b)
> > FROM ( COPY INLINE '/path/to/foo.txt' FORMAT CSV ) as x( a integer, b
> numeric, c text, d date, e json) )
>
> Apologies for bike-shedding, but wouldn't the following be a better
> fit with the current COPY?
>
>     COPY t(a integer, b numeric, c text, d date, e json) FROM
> '/path/to/foo.txt' WITH (FORMAT CSV, INLINE)
>

+1 Very much a better fit.

>
>

Commits

Remove unused struct member, enforce multi_insert callback presence.
- 57a7a3adfe4e 12.0 landed
Separate per-batch and per-tuple memory contexts in COPY
- 36a1281f86c0 12.0 landed
Fix handling of volatile expressions in COPY FROM ... WHERE
- 4a8283d0ec5a 12.0 landed
Allow COPY FROM to filter data using WHERE conditions
- 31f3817402da 12.0 landed
Remove obsolete netbsd dynloader code
- b68ff3ea672c 12.0 cited