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??
Thank you so much!
Shore