How do I copy an element of composite type array into csv file?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: a <372660931(at)qq(dot)com>
Cc: amul sul <sulamul(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How do I copy an element of composite type array into csv file?
Date: 2018-05-23 13:18:52
Message-ID: CAKFQuwbaAV6WA9b7x7_BSGFstDq7Sp_Ui7Q4krx80FkuOn8iXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, May 23, 2018, a <372660931(at)qq(dot)com> wrote:

> 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;
>

you cannot put "[1]" there. The csv file value has to be an array input
literal with only one element. i.e., something like: {(1,2)}

There is no first element as such when you are creating a new record.
There will be however many elelements to supply to the array input.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2018-05-23 13:22:52 RE: RE: How do I select composite array element that satisfy specific conditions.
Previous Message Adrian Klaver 2018-05-23 13:13:45 Re: [GENERAL] Postgre compatible version with RHEL 7.5