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

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

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@xxxxxxxxx>
Sent: Sunday, June 11, 2023 7:30 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: Holger Jakobs <holger@xxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to use long list of columns with COPY command

 

On Sun, Jun 11, 2023 at 4:04 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> 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.