I wish someone will include --disable-indexes when copying/restoring
just like --disable-triggers
Thanks
I hope in pg_dump there should be an option that will
dump a schema without the indexes (except of course primary indexes)
regards
On 2/24/06, Michael Glaesemann [EMAIL PROTECTED] wrote:
Have you looked at the --schema-only flag?http://www.postgresql.org/docs/current/interactive/app-pgdump.htmlIf this doesn't do what you want, can you give a bit more
explanation? Also, what are you trying to do with this dump file?Michael
I think the right question to ask here is why are you so intent onusing separate schema/data restores?That's not the recommended way
to go about things, and it never will be.regards,
tom laneSimply because it took me more or less 24 hours to restore the dump when the
index is already defined. And