My Googlefu is failing me. Are there any code snippets, either in Python or FORTRAN, that shows how to create binary files to be used by the COPY command in PostgreSQL?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Your best bet really is to create CSV files and then import them with COPY. If you want to, you can then wrap them simply in a COPY ... WITH CSV FROM STDIN statement.
The existing docs on the COPY command should be sufficient. See http://www.postgresql.org/docs/9.1/static/sql-copy.html