Skip to content

Instantly share code, notes, and snippets.

@tinogis

tinogis/treure_constraints.sh

Last active December 11, 2015 02:28
Show Gist options
  • Save tinogis/4530283 to your computer and use it in GitHub Desktop.
Save tinogis/4530283 to your computer and use it in GitHub Desktop.
Download ZIP
Neteja constraints de FPCC_tarifa
Raw
treure_constraints.sh
for i in `psql -l -A -t | grep -v 'postgres' | grep -v 'proxy'| cut -d '|' -f 1 `; do
psql -d $i -c "alter table giscedata_liquidacio_fpcc_tarifa DROP CONSTRAINT giscedata_liquidacio_fpcc_tarifa_tarifa_uniq;" ;
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment