Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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');"`
- echo $(date)
- echo "Deleting existing sequences(s) from DB"
- while read -r query; do
- echo "Dropping ${query}"
- echo "$(date)"
- psql \
- -d ${DBNAME} \
- -U ${USER} \
- -h ${HOST} \
- -p 5432 \
- -t \
- -c "${query}"
- done <<< "$seqs_to_delete"
Add Comment
Please, Sign In to add comment