Monitoring database

I don't think there is currently a way to check the database for connections (someone correct me if I'm wrong). But to get a list of all of the tables in template1:

\c template1
select relname from pg_class

Tim
----- Original Message -----
From: Roman Gavrilov
To: pgsql-admin@postgresql.org
Sent: Wednesday, January 09, 2002 3:31 AM
Subject: [ADMIN] Monitoring database

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.
One more question is how can I see all tables in the template1 ?
Thanks allot.

--
-----------------------------------------------------------------------------
Roman Gavrilov
Aduva Inc., Web Development Services.
work +972-3-7534324 mobile +972-54-834668
romio@aduva.com, romio@netvision.net.il

On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:

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: david@stanaway.net
Work: david@netventures.com.au