Show
Ignore:
Timestamp:
10/20/09 14:13:56 (5 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1256048036 +0000
git-parent:

[66c92038a4140676e18fc96716d36bb945eba924]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1256048036 +0000
Message:

a new way of doing this, refs #150

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/README

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