On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
<excerpt>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.
</excerpt>
Take a look here maybe:
http://gborg.postgresql.org/project/pgmonitor/projdisplay.php
<excerpt>One more question is how can I see all tables in the
template1 ?
Thanks allot.
</excerpt>
in the psql client: psql template1
\dt
\h is definately worth reading too.
<fontfamily><param>Helvetica</param>==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au</fontfamily>
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