Thread: Reg:Database and Table information

Reg:Database and Table information

From
"sandhya"
Date:
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
 

Re: Reg:Database and Table information

From
Guido Barosio
Date:
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@amiindia.co.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.