Changeset 13 for trunk/getddl

Show
Ignore:
Timestamp:
05/29/08 19:40:17 (6 years ago)
Author:
robert
Message:

v0.4, adds usage information into the docs

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/getddl/getddl.pl

    r12 r13  
    566566=head1 VERSION 
    567567 
    568 This document refers to version 0.3 of getddl, released April 23, 2008 
     568This document refers to version 0.4 of getddl, released May 29, 2008 
     569 
     570=head1 USAGE 
     571 
     572To use getddl, you need to configure several variables inside the script (mostly having to do with different connection options). Once configured, you call gettdll at the command line.  
     573 
     574Example 1: grab ddl for both the tables and function and dump it to /db/schema/ridley, check-in any modifications or new objects, and remove any entries that no longer exist in svn.  
     575 
     576    perl /home/postgres/getddl.pl --host ridley  --ddlbase /db/schema/ --getddl --getprocs --svn --svndel >>  /home/postgres/logs/getddl.log 
     577 
     578Example 2: grab ddl of only database functions and dump it to /db/schema/kraid. 
     579 
     580    perl /home/postgres/getddl.pl --host kraid --ddlbase /db/schema --getprocs  
     581 
    569582 
    570583=head1 BUGS AND LIMITATIONS 
     
    583596 
    584597=item * clean-up default hosts directives 
     598 
     599=item * validate config options vs. command line options 
    585600 
    586601=item * drop items into thier own directories (ie. host/tables/tblname.sql and host/functions/funcname.sql)