Re: psql - TYPE DEFINITION

Hello Adrian

when I run \dTS+ I get the same result as  \dT+

                            ^
testdb=# create type test AS (a int , b int);
CREATE TYPE
testdb=# \dT+ test
                 List of data types
 Schema | Name | Internal name | Size  | Description
--------+------+---------------+-------+-------------
 public | test | test          | tuple |
(1 row)

testdb=# \dTS+ test
                 List of data types
 Schema | Name | Internal name | Size  | Description
--------+------+---------------+-------+-------------
 public | test | test          | tuple |
(1 row)

Regards

________________________________
From: C Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org; salah jubeh <s_jubeh(at)yahoo(dot)com>
Sent: Monday, January 16, 2012 3:52 PM
Subject: Re: [GENERAL] psql - TYPE DEFINITION

On Monday, January 16, 2012 6:38:49 am salah jubeh wrote:
> Hello
>
>
> I tired \dT and dT+  to see the type related information but I am
> interested about the definition ,  Is there a way to see the type
> definition in psql 

\dTS+

Does the above get you the information you need?

>
> Regards

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com