#!/bin/bash if [ x = "x${1}" ] ; then DBUSER="postgres" else DBUSER="${1}" fi echo "# Nur eigene DB / eigener User" #echo " #SELECT * #FROM pg_stat_activity #WHERE datname = current_database(); #" | sudo -u postgres psql #echo "# Oder" echo " SELECT * FROM pg_stat_activity WHERE usename = '${DBUSER}'; " | sudo -u postgres psql