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 00429D8007 for ; Wed, 14 Sep 2005 02:20:12 -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 90180-07 for ; Wed, 14 Sep 2005 05:20:08 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 25089D7FAF for ; Wed, 14 Sep 2005 02:20:03 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8E5HffT010007; Wed, 14 Sep 2005 10:47:41 +0530 Message-ID: <016401c5b8ec$f9c46ec0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: Reg:Database and Table information Date: Wed, 14 Sep 2005 10:57:19 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0161_01C5B91B.1362BA20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.049 required=5 tests=[AWL=-0.002, FORGED_RCVD_HELO=0.05, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/162 X-Sequence-Number: 18899 This is a multi-part message in MIME format. ------=_NextPart_000_0161_01C5B91B.1362BA20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0161_01C5B91B.1362BA20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
    Is there any way to = find out the=20 information regarding the databases and tables?
I mean,
    Details about = database like=20 ..the time of creation,User who created it,Last Accessed and the=20 user...etc
Similarly for the tables .
Also is there any way to list = out the tables=20 created by a particular user or listing out all the = tables.
 
Pls help me in this..
 
Thank you ,
 
-Sandhya
 
------=_NextPart_000_0161_01C5B91B.1362BA20--