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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings