X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3B33B474E4F for ; Thu, 8 May 2003 11:02:42 -0400 (EDT) Received: from www.trade-india.com (ns1.trade-india.com [66.234.10.14]) by postgresql.org (Postfix) with SMTP id 624F24765EA for ; Thu, 8 May 2003 11:02:39 -0400 (EDT) Received: (qmail 30232 invoked by uid 99); 8 May 2003 15:02:39 -0000 Received: from 219.65.253.168 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Thu, 8 May 2003 20:32:39 +0530 (IST) Message-ID: <1224.219.65.253.168.1052406159.squirrel@mail.trade-india.com> Date: Thu, 8 May 2003 20:32:39 +0530 (IST) Subject: Re: seeing type defination.. From: To: In-Reply-To: <20003.1052403284@sss.pgh.pa.us> References: <200305081145.26591.mallah@trade-india.com> <20003.1052403284@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/167 X-Sequence-Number: 13332 Sorry it works. actually i tried the worng things first i shud have RTFM ;-) 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 schema only ? i have reserved a namespace for holding just return types becoz i cannot specity composites return types while declaring functions like CREATE FUNCTION foo (int , text ) RETURNS SETOF (int , double , text ) AS ' ' language 'blah' ; we need to create a return type first just for that, would it be cool to allow the syntax above ? regds mallah. tradein_clients=3D# \dT custom_return_types.table_desc List of data types Schema | Name | Description ---------------------+------------+------------- custom_return_types | table_desc | (1 row) tradein_clients=3D# \dT+ custom_return_types.table_desc List of data types Schema | Name | Internal name | Size | Description ---------------------+------------+---------------+-------+------------- custom_return_types | table_desc | table_desc | tuple | (1 row) tradein_clients=3D# \d custom_return_types.table_desc Composite type "custom_return_types.table_desc" Column | Type ----------+------ attname | name typeinfo | text tradein_clients=3D# > Rajesh Kumar Mallah writes: >> psql> CREATE TYPE mytype AS (a1 int, a2 varchar(100)) ; > >> is there any way to see the constitution of "mytype" >> at a later date? > > regression=3D# CREATE TYPE mytype AS (a1 int, a2 varchar(100)) ; > CREATE TYPE > regression=3D# \d mytype > Composite type "public.mytype" > Column | Type > --------+------------------------ > a1 | integer > a2 | character varying(100) > > regression=3D# > > regards, tom lane ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/