Importing csv file into postgres

Question

Using Mysql Administrator GUI tool - I have exported some data tables retrieved from an sql dumpfile into csv files.

I then tried to import these csv files into a postgres database using the postgres COPY command. I've tried entering "COPY articles FROM '[insert .csv dir here]' DELIMITERS ',' CSV;" and also the same command without the delimiters part.

I get an error saying "ERROR:invalid input syntax for integer: "id"" and "CONTEXT: COPY articles, line 1, column id: "id"

In conclusion my question is what are some thoughts and solutions to this problem? Could it possibly be something to do with the way I created the csv files? or have I made a rookie mistake elsewhere?

Answer 1

i'm with thegeek. because you already tagged this as a python question, build a handfull-liner script to import this csv file. it's easy, i've made it yesterday because i had a similar problem and no patience with the copy-command of postgres ;)

Answer 2

If you have header columns just add the header qualifier to the copy statement as per documentation to skip that line http://www.postgresql.org/docs/8.4/static/sql-copy.html