Show me exactly what you are doing. I would hope you are staying away from CSV and using tab delimited data.
And study this page: [link|http://www.postgresql.org/docs/8.1/interactive/sql-copy.html|http://www.postgresq...ive/sql-copy.html]
Note this text:
Do not confuse COPY with the psql instruction \\copy. \\copy invokes COPY FROM STDIN or COPY TO STDOUT, and then fetches/stores the data in a file accessible to the psql client. Thus, file accessibility and access rights depend on the client rather than the server when \\copy is used.
I was using INSERT. After all, that's the portable format, isn't it? :-) Besides, that's what MySQL uses for dump-n-restore. I'll be building a migration tool, I think.
Learn it. Use it. Let me know if you neeed any help in working with it. The key issue is let the Postgres backend see the files, do not load through the network.