Peter Eisentraut wrote:
> Is there a reason why COPY TO STDOUT does not allow columns to be specified
> more than once?
>
> pei=# copy test1 (a, a) to stdout;
> ERROR: 42701: column "a" specified more than once
>
> Or is this just an overly extensive check that is actually intended for COPY
> FROM STDIN?
>
>
You should be able to get around it with:
COPY (SELECT a , a FROM test1) TO stdout;
cheers
andew