|
Revision f6540baac0ed25babb2a91d9b715988abb653bcb, 381 bytes
(checked in by Theo Schlossnagle <jesus@omniti.com>, 4 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 |
|---|
