Re: duplicate columns with COPY - Mailing list pgsql-hackers

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