Postgres Pro
Downloads
Home   >   mailing lists

Re: How to view user defined TYPE - Mailing list pgsql-general

From Tom Lane
Subject Re: How to view user defined TYPE
Date
Msg-id 10102.1224696934@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to view user defined TYPE  (Goboxe <hadzramin.ar@gmail.com>)
List pgsql-general
Tree view 
Goboxe <hadzramin.ar@gmail.com> writes:
>> Let say I created a new type:
>> CREATE TYPE compfoo AS (f1 int, f2 text);
>> How can I view its definition?

In psql, \d works:

regression=# CREATE TYPE compfoo AS (f1 int, f2 text);
CREATE TYPE
regression=# \d compfoo
Composite type "public.compfoo"
 Column |  Type
--------+---------
 f1     | integer
 f2     | text


            regards, tom lane

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: text array accumulate to multidimensional text array
Next
From: "George Pavlov"
Date:
Subject: Re: How to get schema name which violates fk constraint