i have a perl script that does the following: 1. dump the schemas some 7-12 times first. you can increase the number depending on how deep your dependencies are. this is brute force like, hoping that the most depended-upon structure gets created successfully, then the next level, and so on. 2. get a list of tables 3. dump the tables one by one dumping complete sql statements
On Thu, 9 Sep 2004 14:47:04 +0800, Bopolissimus Platypus Jr <[EMAIL PROTECTED]> wrote: > thanks. i've looked into doing it manually. if anyone else > has suggestions (e.g., are there smarter dumping tools > or software based workarounds, even pg_dump parsers > that will do the reordering), please, chime in :). > > tiger -- Seek ye first the kingdom of God and all these things shall be added unto you. Winelfred G. Pasamba Adventist University of the Philippines Computer Science Department, AUP Online Information System -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
