Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0CC909FB57F for ; Wed, 23 May 2007 07:57:29 -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 29777-06 for ; Wed, 23 May 2007 07:57:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id 2AC3C9FB4C7 for ; Wed, 23 May 2007 07:57:20 -0300 (ADT) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id B2B9D440D5; Wed, 23 May 2007 12:57:54 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 918C6C44291 for ; Wed, 23 May 2007 12:57:17 +0200 (CEST) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22046-06 for ; Wed, 23 May 2007 12:57:17 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 45C2BC4428E for ; Wed, 23 May 2007 12:57:17 +0200 (CEST) Message-ID: <46541E0C.3010301@proventis.net> Date: Wed, 23 May 2007 12:57:16 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: 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: multipart/mixed; boundary="------------090303000505020501030500" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/240 X-Sequence-Number: 25560 This is a multi-part message in MIME format. --------------090303000505020501030500 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit use tables/views in scheme pg_catalog/information_schema try select * from pg_catalog.pg_database; select * from pg_catalog.pg_user; select * from pg_catalog.pg_tables; Mondi Ravi schrieb: > i can't find out command to show all databases,tables,users and > integrity constraints relationships; > yours sincerely > > > ---------------------------(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 > --------------090303000505020501030500 Content-Type: text/x-vcard; charset=utf-8; name="t.markus.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="t.markus.vcf" begin:vcard fn:Thomas Markus n:Markus;Thomas org:proventis GmbH adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany email;internet:t.markus@proventis.net tel;work:+49 30 29 36 399 22 x-mozilla-html:FALSE url:http://www.proventis.net version:2.1 end:vcard --------------090303000505020501030500--