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)
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.klaver@xxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx; salah jubeh <s_jubeh@xxxxxxxxx>
Sent: Monday, January 16, 2012 3:52 PM
Subject: Re: 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.klaver@xxxxxxxxx
