From: mallah@trade-india.com
To: tgl@sss.pgh.pa.us
Cc: pgsql-sql@postgresql.org
Subject: Re: seeing type defination..
Date: Thu, 8 May 2003 20:32:39 +0530 (IST)
Message-ID: <1224.219.65.253.168.1052406159.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <20003.1052403284@sss.pgh.pa.us>
References: <200305081145.26591.mallah@trade-india.com>
<20003.1052403284@sss.pgh.pa.us>
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=# \dT custom_return_types.table_desc
List of data types
Schema | Name | Description
---------------------+------------+-------------
custom_return_types | table_desc |
(1 row)
tradein_clients=# \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=# \d custom_return_types.table_desc
Composite type "custom_return_types.table_desc"
Column | Type
----------+------
attname | name
typeinfo | text
tradein_clients=#
> Rajesh Kumar Mallah <mallah@trade-india.com> 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=# CREATE TYPE mytype AS (a1 int, a2 varchar(100)) ;
> CREATE TYPE
> regression=# \d mytype
> Composite type "public.mytype"
> Column | Type
> --------+------------------------
> a1 | integer
> a2 | character varying(100)
>
> regression=#
>
> regards, tom lane
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us
Subject: Re: seeing type defination..
In-Reply-To: <1224.219.65.253.168.1052406159.squirrel@mail.trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox