Problem when using the COPY command with Postgresql

Question

I'm trying to load data into a table called points using the following SQL syntax:

COPY points (id, address)
    FROM '$HOME/data/testdataReduced.csv'
    WITH 
          DELIMITER AS ','
          CSV HEADER ;

The error message that I received is the following:

ERROR: must be superuser to COPY to or from a file

Is there any way that I can load data in using this approach? I want to have a php file that would run SQL to load in data as a batch process ever 24 hours so I would prefer not to use psql.

Answer 1

0	You can't use COPY, for the reason stated in the error message. Instead, have your PHP script step through your CSV file, doing an INSERT for each row of data. Hope that helps! permanent link answered 27 Aug '12, 12:47 seanf 12.2k●4●21●36 accept rate: 37% edited 27 Aug '12, 12:47

Problem when using the COPY command with Postgresql

Follow this question

Related questions