I'm trying to load data into a table called
The error message that I received is the following:
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. asked 27 Aug '12, 05:35 womble |
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! answered 27 Aug '12, 12:47 seanf |