Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B89509FB5F1 for ; Wed, 23 May 2007 05:56:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 66903-01 for ; Wed, 23 May 2007 05:56:41 -0300 (ADT) X-Greylist: delayed 00:06:38.103618 by SQLgrey-1.7.5 Received: from smtp5.wlink.com.np (smtp5.wlink.com.np [202.79.32.52]) by postgresql.org (Postfix) with SMTP id 23E629FB5A1 for ; Wed, 23 May 2007 05:56:38 -0300 (ADT) Received: (qmail 1574 invoked from network); 23 May 2007 08:49:52 -0000 Received: from unknown (HELO smtp8.wlink.com.np) (202.79.32.38) by 0 with SMTP; 23 May 2007 08:49:52 -0000 Received: (qmail 82013 invoked by uid 98); 23 May 2007 08:49:52 -0000 Received: from 202.79.32.77 by smtp8.wlink.com.np (envelope-from , uid 1004) with qmail-scanner-1.25 (clamdscan: 0.88.4/1879. Clear:RC:1(202.79.32.77):. Processed in 0.024305 secs); 23 May 2007 08:49:52 -0000 X-Qmail-Scanner-Mail-From: ravimondi@wlink.com.np via smtp8.wlink.com.np X-Qmail-Scanner: 1.25 (Clear:RC:1(202.79.32.77):. Processed in 0.024305 secs) Received: from smtp2.wlink.com.np (202.79.32.77) by smtp8.wlink.com.np with SMTP; 23 May 2007 08:49:52 -0000 Received: (qmail 27691 invoked by uid 516); 23 May 2007 08:49:51 -0000 Received: from [202.79.36.127] (HELO [202.79.36.127]) by smtp2.wlink.com.np (qmail-smtpd) with SMTP; 23 May 2007 08:49:50 -0000 (Wed, 23 May 2007 14:34:50 +0545) Subject: how to view all database,tables,users From: Mondi Ravi To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: wlink Date: Wed, 23 May 2007 14:38:58 +0545 Message-Id: <1179910438.3908.2.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.0 (2.8.0-7.fc6) Content-Transfer-Encoding: 7bit X-Spam-Check-By: smtp2.wlink.com.np Spam: No ; 0.3 / 7.0 X-Spam-Status-WL: No, hits=0.3 required=7.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/238 X-Sequence-Number: 25558 i can't find out command to show all databases,tables,users and integrity constraints relationships; yours sincerely