Thanks, guys,
This told me that the user that has it open is the interface user
called db_user. Is there a command to disconnect this user?
Carol
On Jul 3, 2008, at 3:53 PM, Kevin Grittner wrote:
Carol Walter <walterc@xxxxxxxxxxx> wrote:
I'm trying to drop a database and I'm getting an error that says that
the database is being accessed by other users. Is there a way I can
find out who these users are or if there really is a user accessing
it?
select * from pg_stat_activity where datname = 'yourdb';
-Kevin
