Guest User

Untitled

a guest
Oct 19th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. seqs_to_delete=`psql -d ${DBNAME} -U ${USER} -h ${HOST} -p 5432 -t -c "SELECT 'drop sequence ' || c.relname || ';' FROM pg_class c WHERE (c.relkind = 'S');"`
  2. echo $(date)
  3. echo "Deleting existing sequences(s) from DB"
  4. while read -r query; do
  5. echo "Dropping ${query}"
  6. echo "$(date)"
  7. psql \
  8. -d ${DBNAME} \
  9. -U ${USER} \
  10. -h ${HOST} \
  11. -p 5432 \
  12. -t \
  13. -c "${query}"
  14. done <<< "$seqs_to_delete"
Add Comment
Please, Sign In to add comment