On Mon, Mar 28, 2016 at 9:35 AM, Rick Otten <rotten@windfish.net> wrote:
> So the problem is a column order thing and not something buried in my
> jsonb data. Mr. Johnston was very helpful in resolving this.
>
> Apparently when you do a "copy from with csv header", the 'header' phrase
> is ignored in spite of the keyword being present in your statement.
>
=E2=80=8BIt is not ignored - it is informing COPY that the first line of yo=
ur input
file is not data but meta-data and thus must be ignored.=E2=80=8B
There are external utilities available that make doing the whole copy thing
much more user-friendly. Given their existence not much effort is expended
trying to enhance the native copy facilities beyond making it extremely
fast for bulk loading well-specified data.
David J.