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";<[email protected]>; Send time: Wednesday, May 23, 2018 5:11 PM To: "a"<[email protected]>; Cc: "pgsql-general"<[email protected]>; 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 <[email protected]> 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
