git://git.onelab.eu / myplc.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
history | raw | HEAD
check_hrns.py: external Sites are tagged with sfa_created=='True'
[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