Thank you so much. BTW, may I ask one more question that, how should I select every first element of the array??
I know that "select p[:] from f" will print all element of the p array, but I probably would want to present result as "select p[:].a from f", but the statement does not work.
May I as the correct statement of displaying all first element of the composite type in an array??
Thank you!
Shore
------------------ Original message ------------------
From: "Pavel Stehule";
Sendtime: Friday, May 18, 2018 5:46 PM
To: "a"<372660931@qq.com>;
Cc: "pgsql-general";
Subject: Re: Importing data from CSV into a table with array and composite types