On Wed, May 23, 2018 at 2:05 PM, a <372660931@xxxxxx> wrote: > Hi suppose I have composite type and table > > create type A as( > x float8, > y float8 > ); > > create table B( > Ay A[] > ); > > insert into B > values(array[ > (1,2)::A, > (3,4)::B] > ); > > Now I would like to export the first element of table B into an csv file: > > COPY B(Ay[1]) > to 'E:/products_199.csv' DELIMITER ',' CSV HEADER; > > The code above reported an syntax error. > > How should I do it?? > Try COPY (SELECT Ay[1] FROM B) to 'E:/products_199.csv' DELIMITER ',' CSV HEADER; Regards, Amul
