Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8FD359FB8B5 for ; Thu, 24 May 2007 03:38:43 -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 04714-04 for ; Thu, 24 May 2007 03:38:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s36.bay0.hotmail.com (bay0-omc3-s36.bay0.hotmail.com [65.54.246.236]) by postgresql.org (Postfix) with ESMTP id 832A39FB816 for ; Thu, 24 May 2007 03:38:39 -0300 (ADT) Received: from hotmail.com ([207.46.11.81]) by bay0-omc3-s36.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 23 May 2007 23:38:38 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 23 May 2007 23:38:37 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Thu, 24 May 2007 06:38:34 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <1179910438.3908.2.camel@localhost.localdomain> From: "Vishal Arora" To: ravimondi@wlink.com.np Cc: pgsql-admin@postgresql.org Subject: Re: how to view all database,tables,users Date: Thu, 24 May 2007 06:38:34 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 24 May 2007 06:38:37.0858 (UTC) FILETIME=[28E9C020:01C79DCE] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.75 tagged_above=0 required=5 tests=AWL=-0.418, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: X-Archive-Number: 200705/257 X-Sequence-Number: 25577 Apart from select statements you can use the following commands on psql prompt - \d [NAME] describe table, index, sequence, or view \d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables \da [PATTERN] list aggregate functions \db [PATTERN] list tablespaces (add "+" for more detail) \dc [PATTERN] list conversions \dC list casts \dd [PATTERN] show comment for object \dD [PATTERN] list domains \df [PATTERN] list functions (add "+" for more detail) \dg [PATTERN] list groups \dn [PATTERN] list schemas (add "+" for more detail) \do [NAME] list operators \dl list large objects, same as \lo_list \dp [PATTERN] list table, view, and sequence access privileges \dT [PATTERN] list data types (add "+" for more detail) \du [PATTERN] list users \l list all databases (add "+" for more detail) \z [PATTERN] list table, view, and sequence access privileges (same as \dp) Hope this would answer your query. >From: Mondi Ravi >To: pgsql-admin@postgresql.org >Subject: [ADMIN] how to view all database,tables,users >Date: Wed, 23 May 2007 14:38:58 +0545 > >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 _________________________________________________________________ Like the way Microsoft Office Outlook works? You’ll love Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_outlook_0507