root/sql/dump.sh

Revision f6540baac0ed25babb2a91d9b715988abb653bcb, 381 bytes (checked in by Theo Schlossnagle <jesus@omniti.com>, 6 years ago)

flag-day(stratcond,database) partition the loading docks, refs #140

  • Property mode set to 100755
Line 
1 #!/bin/sh
2
3 PARTS=`psql reconnoiter postgres << EOF | egrep '_[0-9]'
4 \a
5    select nspname||'.'||relname
6      from pg_class as c join pg_namespace as n on(c.relnamespace = n.oid)
7     where relname ~ '_[0-9]{6}$';
8 EOF
9 `
10
11 for part in $PARTS
12 do
13         EXCLUDE="$EXCLUDE --exclude-table=$part"
14 done
15 pg_dump -s -n stratcon $EXCLUDE -n prism -U postgres reconnoiter  > reconnoiter_ddl_dump.sql
Note: See TracBrowser for help on using the browser.