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

Re: Reg:Database and Table information

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: sandhya <sandhyar(at)amiindia(dot)co(dot)in>
Cc: postgre <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reg:Database and Table information
Date: 2005-09-15 20:45:59
Message-ID: f7f6b4c705091513452aa65062@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Sandhya,
 Well, actually the man pages explain very well how to gather this kind of 
information.
I strongly suggest you to reach http://www.postgresql.org where you will 
find these details in a very comprehensive way.
 Basically, you will find that there are views that will give you the 
information that you need. Most of them start with the pg_* prefix. But as I 
told you, I highly encourage you to get rid of that documentation. You will 
find it extremely usefull.
 If you do not understand those papers, contact me and I will kindly try to 
sort out your doubts.
 Best wishes,
Guido.


 On 9/14/05, sandhya <sandhyar(at)amiindia(dot)co(dot)in> wrote: 
> 
> Hi,
>   Is there any way to find out the information regarding the databases and 
> tables?
> I mean,
>  Details about database like ..the time of creation,User who created 
> it,Last Accessed and the user...etc
> Similarly for the tables .
> Also is there any way to list out the tables created by a particular user 
> or listing out all the tables.
>  Pls help me in this..
>  Thank you ,
>  -Sandhya
>  



-- 
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

In response to

pgsql-admin by date

Next:From: Guido BarosioDate: 2005-09-15 20:47:31
Subject: Re: 7.4 <-> 8.0
Previous:From: Guido BarosioDate: 2005-09-15 20:35:40
Subject: Re: 7.4 <-> 8.0

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