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

P {margin-top:0;margin-bottom:0;}

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

---

COPY using something else than STDIN is only allowed for superusers.

COPY also uses file paths on the server, and the files have to be readable by the system account running the server, usually postgres.

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012