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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Am 12.06.23 um 01:45 schrieb M Sarwar:
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.

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

Attachment: OpenPGP_signature
Description: OpenPGP digital signature

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux