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.
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:
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).