Thank you very much.
BTW, may I ask if I would like to do the opposite that copy csv file content into the first element, how should I do it?? COPY B(Ay[1]) from 'E:/products_199.csv' DELIMITER ',' CSV HEADER; ------------------ Original ------------------ From: "amul sul";<sula...@gmail.com>; Send time: Wednesday, May 23, 2018 5:11 PM To: "a"<372660...@qq.com>; Cc: "pgsql-general"<pgsql-gene...@postgresql.org>; Subject: Re: How do I copy an element of composite type array into csv file? On Wed, May 23, 2018 at 2:05 PM, a <372660...@qq.com> 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