git://git.onelab.eu / myplc.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw (from parent 1: 0f8c747)
Merge branch 'master' of ssh://git.onelab.eu/git/myplc
authorThierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Mon, 4 Oct 2010 12:33:43 +0000 (14:33 +0200)
committerThierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Mon, 4 Oct 2010 12:33:43 +0000 (14:33 +0200)
bin/spot-dup-accounts.sh [new file with mode: 0755] patch | blob

diff --git a/bin/spot-dup-accounts.sh b/bin/spot-dup-accounts.sh
new file mode 100755 (executable)
index 0000000..b7238f6
--- /dev/null
+++ b/bin/spot-dup-accounts.sh
@@ -0,0 +1,7 @@
+#!/bin/bash
+
+DB=planetlab5
+USER=pgsqluser
+CMD="select email, count(email) from persons where deleted=false group by email having count(email) > 2;"
+
+psql -U $USER $DB -c "$CMD"
myplc