X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A65FD902A for ; Thu, 15 Sep 2005 17:46:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36708-10 for ; Thu, 15 Sep 2005 20:46:01 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.200]) by svr1.postgresql.org (Postfix) with ESMTP id 1769BD900F for ; Thu, 15 Sep 2005 17:45:58 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c2so43498nfe for ; Thu, 15 Sep 2005 13:45:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=AcISNBLq2HmJ6PiK30RTDOPC+wVp6GCqvryxghWoOt+VZDSpGkVpQuZEaralPDLLPoyDcZjJnn6XCcm4wcAicsa5XMiZXsWLNUkZS7SgXCLnxc9MFN6vx7qyEbyOeIMVYp7Unfv0ZsAHOTEaasDQKLp7opzrOY02JaCiu/Wm2b4= Received: by 10.48.144.4 with SMTP id r4mr49497nfd; Thu, 15 Sep 2005 13:45:59 -0700 (PDT) Received: by 10.48.250.10 with HTTP; Thu, 15 Sep 2005 13:45:59 -0700 (PDT) Message-ID: Date: Thu, 15 Sep 2005 21:45:59 +0100 From: Guido Barosio Reply-To: gbarosio@gmail.com To: sandhya Subject: Re: Reg:Database and Table information Cc: postgre In-Reply-To: <016401c5b8ec$f9c46ec0$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27553_384700.1126817159801" References: <016401c5b8ec$f9c46ec0$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.182 required=5 tests=[AWL=0.062, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/177 X-Sequence-Number: 18914 ------=_Part_27553_384700.1126817159801 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Sandhya, Well, actually the man pages explain very well how to gather this kind of= =20 information. I strongly suggest you to reach http://www.postgresql.org where you will=20 find these details in a very comprehensive way. Basically, you will find that there are views that will give you the=20 information that you need. Most of them start with the pg_* prefix. But as = I=20 told you, I highly encourage you to get rid of that documentation. You will= =20 find it extremely usefull. If you do not understand those papers, contact me and I will kindly try to= =20 sort out your doubts. Best wishes, Guido. On 9/14/05, sandhya wrote:=20 >=20 > Hi, > Is there any way to find out the information regarding the databases an= d=20 > tables? > I mean, > Details about database like ..the time of creation,User who created=20 > 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= =20 > or listing out all the tables. > Pls help me in this.. > Thank you , > -Sandhya > =20 --=20 "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. ------=_Part_27553_384700.1126817159801 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 c= omprehensive way.
 
Basically, you will find that there are views that will give you the i= nformation 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 wil= l find it extremely usefull.
 
If you do not understand those papers, contact me and I will kindly tr= y to sort out your doubts.
 
Best wishes,
Guido.


 
On 9/14/05, = sandhya <sandhyar@amiindi= a.co.in> wrote:
Hi,
 
    Is there any way to= find out the information regarding the databases and tables?
I mean,
    Details about datab= ase like ..the time of creation,User who created it,Last Accessed and the u= ser...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 yo= u are smarter than an automatic
optimization algorithm is generally a go= od way to achieve less
performance, not more" - Tom Lane.=20 ------=_Part_27553_384700.1126817159801--