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

Reply via email to