Re: How to use long list of columns with COPY command

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: Holger Jakobs <holger(at)jakobs(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to use long list of columns with COPY command
Date: 2023-06-11 23:30:23
Message-ID: CAKFQuwYowKF30pz1QDch+RPZHKC24TQ6bpjoguyqUnLoZW7ySA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Jun 11, 2023 at 4:04 PM M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:

> \COPY
>

psql \copy and SQL COPY are not the same thing. Haven't tested but SQL
COPY shouldn't have this limitation. Use it instead (you never have to use
psql \copy, it is only a convenient shortcut).

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-06-11 23:45:51 Re: How to use long list of columns with COPY command
Previous Message M Sarwar 2023-06-11 23:04:30 Re: How to use long list of columns with COPY command