]> gitweb.pimeys.fr Git - scripts-20-100.git/blob - bde/stats/soldes.sh
37d9a71ec2c976a5abe5967cd2cd57cc9c157d35
[scripts-20-100.git] / bde / stats / soldes.sh
1 #!/bin/bash
2
3 # Affiches tous les comptes avec leur solde, par ordre décroissant
4
5 if [[ "$1" = "--no-club" ]]
6 then
7 psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents WHERE NOT club ORDER BY solde DESC;"
8 else
9 psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents ORDER BY solde DESC;"
10 fi
11