Hello everybody.
Is there any way to check database status, or who is currently connected to it.
I tried to drop database and got an error saying that other users using this database.
So I wanted to see who is connected right now to the database.
Take a look here maybe:
http://gborg.postgresql.org/project/pgmonitor/projdisplay.php
One more question is how can I see all tables in the template1 ?
Thanks allot.
in the psql client: psql template1
\dt
\h is definately worth reading too.
==============================
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]