Now I need to copy an instance of "pa" with his descendants from my backup (a postgres dump) back to prod. "grandchild" has a blob column (containing fotos)
Which options do I have?
1) Import the backup dump in a separate postgres instance 2) Do some magic query which created insert statements 3) Run the insert statements on the prod server
What is the best approach, and how does a query look like which returns nicely formatted insert lines?