I'm no Postgresql expert, but I've used the builtin "COPY" SQL command. You can find the documentation on it here: http://www.postgresql.org/docs/8.3/interactive/sql-copy.html Note: 1. Using COPY in this way is that Postgresql will create the csv file on the server's filesystem, not on your client machine, if you use a different machine for server and client. 2. when you create the file, the directory that you create the file in must be writable by Postgres, I just always use /tmp as anyone can create files in that directory. 3. #2 is probably specific to UNIX environments like Linux or MacOS X. HTH, -Joshua Joshua Berry |
