By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

How to Copy a Table that includes a BLOB

P: 2
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
May 13 '10 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
Use pg_dump. See here for manual
http://www.postgresql.org/docs/curre...pp-pgdump.html
May 13 '10 #2

P: 2
Very cool, thank you!
May 14 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.