Postgres Pro
Downloads
Home   >   mailing lists

how to see all tables/object in db - Mailing list pgsql-novice

From Isabella Ghiurea
Subject how to see all tables/object in db
Date
Msg-id 48F8D9C2.1090908@nrc-cnrc.gc.ca
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Ennio-Sr
Date:
Subject: How to transform pg_7.4 function 'to_number' to 8.4 equivalent?
Next
From: Tom Lane
Date:
Subject: Re: "timestamp without timezone" and at "time zone"