Re: Added tab completion for the missing options in copy statement - Mailing list pgsql-hackers

From vignesh C
Subject Re: Added tab completion for the missing options in copy statement
Date
Msg-id CALDaNm2RStfEuLEHLhrGxAVQqU=odbofOCKAxaHgPY15e8G7DQ@mail.gmail.com
Whole thread Raw
In response to Re: Added tab completion for the missing options in copy statement  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Added tab completion for the missing options in copy statement
List pgsql-hackers
On Sat, Jul 18, 2020 at 4:36 PM Michael Paquier <michael@paquier.xyz> wrote:
>
> On Sat, Jul 18, 2020 at 04:12:02PM +0530, vignesh C wrote:
> > Can we specify Insert/Update or delete with copy?
> > When I tried few scenarios I was getting the following error:
> > ERROR:  COPY query must have a RETURNING clause
> >
> > I might be missing some scenarios, just wanted to confirm if this is
> > kept intentionally.
>
> This error message says it all, this is supported for a DML that
> includes a RETURNING clause:
> =# create table aa (a int);
> CREATE TABLE
> =# copy (insert into aa values (generate_series(2,5)) returning a)
>      to '/tmp/data.txt';
> COPY 4
> =# \! cat /tmp/data.txt
> 2
> 3
> 4
> 5
>

Thanks Michael for the clarification, the patch looks fine to me.


Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Patch for nodeIncrementalSort comment correction.
Next
From: vignesh C
Date:
Subject: Re: Add header support to text format and matching feature