Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A63A89FB250 for ; Wed, 23 May 2007 09:04:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 06223-06 for ; Wed, 23 May 2007 09:04:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.wp.pl (mx1.wp.pl [212.77.101.5]) by postgresql.org (Postfix) with ESMTP id 5C4A69FB22C for ; Wed, 23 May 2007 09:04:06 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 24924 invoked from network); 23 May 2007 14:04:04 +0200 Received: from ip-213-17-164-70.netia.com.pl (HELO [127.0.0.1]) (ipluta@[213.17.164.70]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with SMTP for ; 23 May 2007 14:04:04 +0200 Message-ID: <46542DAE.4000501@wp.pl> Date: Wed, 23 May 2007 14:03:58 +0200 From: Ireneusz Pluta User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Mondi Ravi CC: pgsql-admin@postgresql.org Subject: Re: how to view all database,tables,users References: <1179910438.3908.2.camel@localhost.localdomain> In-Reply-To: <1179910438.3908.2.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/242 X-Sequence-Number: 25562 Mondi Ravi napisał(a): > i can't find out command to show all databases,tables,users and > integrity constraints relationships; > yours sincerely See tables and views of system catalogs: http://www.postgresql.org/docs/8.2/interactive/catalogs.html and use just SELECT statements on them to get what want. You may use some of: http://www.postgresql.org/docs/8.2/interactive/functions-info.html http://www.postgresql.org/docs/8.2/interactive/functions-admin.html functions in these statements. > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > > >