Re: [HACKERS] suggestion

2006-03-19 Thread Jan Cruz
I wish someone will include --disable-indexes when copying/restoring just like --disable-triggers Thanks

[HACKERS] suggestion

2006-02-23 Thread Jan Cruz
I hope in pg_dump there should be an option that will dump a schema without the indexes (except of course primary indexes) regards

Re: [HACKERS] suggestion

2006-02-23 Thread Jan Cruz
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

Re: [HACKERS] suggestion

2006-02-23 Thread Jan Cruz
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