X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fadhesions.sh;fp=bde%2Fadhesions.sh;h=b3e141dad9ea2884981f19d936c880db6967dd26;hb=ff089bb4616f2b0e3a4cb30c57682b497a505665;hp=0000000000000000000000000000000000000000;hpb=0af61e04c1a2575f983ed8e5efa07efbf04eaa0a;p=scripts-20-100.git

diff --git a/bde/adhesions.sh b/bde/adhesions.sh
new file mode 100755
index 0000000..b3e141d
--- /dev/null
+++ b/bde/adhesions.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+# Pour trouver les années d'adhésion d'un compte
+
+export LESS='-S'
+
+psql note -c "
+   SELECT *
+   FROM adhesions
+   WHERE idbde = $1
+   ORDER BY annee ASC;"