title: How to read postgresql dump file in Python
body: <p>I'd like my Python script to read some data out of a postgresql dump file. The Python will be running on a system without postgresql, and needs to process the data in a dump file.</p>
  
  <p>It looks fairly straightforward to parse the CREATE TABLE calls to find the column names, then the INSERT INTO rows to build the contents.  But I'm sure there would be quite a few gotchas in doing this reliably.  Does anyone know of a module which will do this?</p>