Re: How to use long list of columns with COPY command - Mailing list pgsql-admin

From M Sarwar
Subject Re: How to use long list of columns with COPY command
Date
Msg-id DM4PR19MB59781DC079998909E2A5FCBAD357A@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: How to use long list of columns with COPY command  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to use long list of columns with COPY command
List pgsql-admin
Hi David,
I appreciate your response.
I tried to run COPY from SQL and I got the below error message.

ERROR: COPY from a file is not supported HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone. SQL state: 0A000

Here is my code:

COPY bronx.TEST_GLOBAL_MCM_RAW (single_date_a, single_start_time_b, dual_part_m, dual_data_n ) FROM 'C:\Mohammed\Work\NGC\Apps\Bronx\Tables\Test_TestData_MCM\Test_TestData_MCM-LoadData\N541652_IN3799A0_CLD_ABMN.csv'  DELIMITER ','  CSV Header ;

 

I am trying to load the data from CSV file to the postgres database.
Thanks,
Sarwar


From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Sunday, June 11, 2023 7:30 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to use long list of columns with COPY command
 
On Sun, Jun 11, 2023 at 4:04 PM M Sarwar <sarwarmd02@outlook.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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to use long list of columns with COPY command
Next
From: Laurenz Albe
Date:
Subject: Re: How to use long list of columns with COPY command