How to Copy a Table that includes a BLOB

[vcomp]

I have a table that includes BLOBs which are audio files. I need to copy the table to another database. Normally I just copy the records and insert them into the second table but I'm guessing I can't do that with a BLOB. Any suggestions on how to accomplish this task?

Thanks,

Vic

[rski]

Use pg_dump. See here for manual

http://www.postgresql.org/docs/current/static/app-pgdump.html

[vcomp]

Very cool, thank you!