Обсуждение: Reg:Database and Table information
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
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...etcSimilarly 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.