Cannot COPY xmin? - Mailing list pgsql-general

From Dominique Devienne
Subject Cannot COPY xmin?
Date
Msg-id CAFCRh-8LTZrtELwXsO04XT83sn2v_GpHWQ3=q11wLPi2yCL5ug@mail.gmail.com
Whole thread Raw
Responses Re: Cannot COPY xmin?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
Hi. I just tried adding the xmin pseudo-column to my COPY,
and I get an error. Using a regular SELECT works fine.

Is that normal? that's a `COPY tab(xmin, cols...) ...`

Do I need to switch to a `COPY (select xmin, cols... from tab) ...` to access xmin?

And if I do that, any performance implications for the COPY?
The reason I'm using COPY is performance and its "streaming" behavior.
(modulo the "big row" non-streaming issue from my as-yet unanswered post from today).
I'm thus interested in how a `COPY tab(cols...)` differs from a `COPY (select cols from tab ...)` in terms of implementation and performance.

Thanks, --DD

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Me again with an insert trigger problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Cannot COPY xmin?