- 10/20/09 14:13:56 (7 years ago)
r37c50c6 rfe61445 1 == Snap the schema off a live machine== 1 == == 2 2 3 pg_dump -s -n stratcon -n prism -U postgres reconnoiter > reconnoiter_ddl_dump.sql 3 Tables are in tables/, stored procedures/functions are in sprocs/ 4 5 The scaffolding.sql file is used to glue them all together in the right order? 6 Convoluted? perhaps. It allows us to manipulate small sections of the schema 7 as code, stored in version control, and reconstitute the database easily for 8 testing.