git://git.onelab.eu / myplc.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
history | raw | HEAD
Setting tag myplc-5.3-5
[myplc.git] / bin / spot-dup-accounts.sh
1 #!/bin/bash
2
3 DB=planetlab5
4 USER=pgsqluser
5 CMD="select email, count(email) from persons where deleted=false group by email having count(email) > 2;"
6
7 psql -U $USER $DB -c "$CMD"
myplc