Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group