May 2018
Intermediate to advanced
576 pages
30h 25m
English
Issue the following query to see whether the bob user is connected:
SELECT datname FROM pg_stat_activity WHERE usename = 'bob';
If this query returns any rows, then it means bob is connected to the database. The returned value is the name of the database to which the user is connected.