how to see all tables/object in db

From: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to see all tables/object in db
Date: 2008-10-17 18:30:26
Message-ID: 48F8D9C2.1090908@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello gurus PG,
Here are my novice questions:
1- how to see all tables/objects in a db , in psql I tried: list
tables or describe table none will work . And can't find to much info
in online PG docs
2- how to see all the ( active or not) user connections,: users names,
hosts , apps_name. cmd running etc in a db ?
3- how to kill a user connection in PG cluster db ?

thanks in advance
Isabella

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-10-17 18:36:58 Re: "timestamp without timezone" and at "time zone"
Previous Message Morris, Roy 2008-10-17 18:26:02 Re: How to transform pg_7.4 function 'to_number' to 8.4 equivalent?