Hi, > > > > 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? > > > > >
This seems to be a common check in both "COPY TO" and "COPY FROM" cases source/destination being STDIN or otherwise. While it definitely makes sense for the FROM case maybe we could relax this for the COPY TO case. Regards, Nikhils -- EnterpriseDB http://www.enterprisedb.com