Re: psql - TYPE DEFINITION - Mailing list pgsql-general

From salah jubeh
Subject Re: psql - TYPE DEFINITION
Date
Msg-id 1326735856.538.YahooMailNeo@web161503.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: psql - TYPE DEFINITION  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: psql - TYPE DEFINITION  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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.klaver@gmail.com>
To: pgsql-general@postgresql.org; salah jubeh <s_jubeh@yahoo.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.klaver@gmail.com


pgsql-general by date:

Previous
From: Dennis Runz
Date:
Subject: 2D array aggregation performance (array_agg for arrays)
Next
From: Evert Koks
Date:
Subject: postgres Windows distribution - openssl support