X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 573A447663D for ; Thu, 8 May 2003 11:17:42 -0400 (EDT) Received: from www.trade-india.com (ns1.trade-india.com [66.234.10.14]) by postgresql.org (Postfix) with SMTP id 506C2476601 for ; Thu, 8 May 2003 11:17:41 -0400 (EDT) Received: (qmail 31548 invoked by uid 99); 8 May 2003 15:17:46 -0000 Received: from 219.65.253.168 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Thu, 8 May 2003 20:47:46 +0530 (IST) Message-ID: <1232.219.65.253.168.1052407066.squirrel@mail.trade-india.com> Date: Thu, 8 May 2003 20:47:46 +0530 (IST) Subject: Re: seeing type defination.. From: To: In-Reply-To: <20513.1052406357@sss.pgh.pa.us> References: <200305081145.26591.mallah@trade-india.com> <20003.1052403284@sss.pgh.pa.us> <1224.219.65.253.168.1052406159.squirrel@mail.trade-india.com> <20513.1052406357@sss.pgh.pa.us> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-24.9 required=5.0 tests=BAYES_01,IN_REP_TO,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME, NO_REAL_NAME,QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/170 X-Sequence-Number: 13335 Oops great! i just missed by a '.' Thanks Mallah. tradein_clients=3D# \dT custom_return_types* List of data types Schema | Name | Description --------+------+------------- (0 rows) tradein_clients=3D# tradein_clients=3D# \dT custom_return_types.* List of data types Schema | Name | Description ---------------------+------------------------------------+------------- custom_return_types | custom_return_types.login_response | custom_return_types | custom_return_types.table_desc | (2 rows) > writes: >> by the way there is still a lacuna i cannot exclusively list >> my custom return types within a schema , the pg_catalog >> name space is always included and have typically 60 type >> entries , so when i do >> \dT everything is listed will it be possible in 7.4 to list types in a s= chema only ? > > \dT myschema.* > > regards, tom lane ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/