database - How to display all the types that i've created using "CREATE TYPE" in postgresql? -


Hello, this may sound like a silly question, but .. I have created several types of "type" TYPE command, now I would like to use the same type in a different type of database in a different server and did not save my CREATE TYPE statement. Is there any way to export type ?? Or even show a list of their fields and types of fields?

This uses pgAdmin3:

  SELECT t.oid , T *, Format_type (t.oid, NULL) AS ALIAS, pg_get_userbyid (t.typowner) AS Typener, ETPN Include A element, description, ct.oid AS Pg_type T on the pg_type e. e.oid = t.typelem LEFT OUTER pg_class whistle ON ct.oid = t.typrelid and ct.relkind & lt; & Gt; Include 'C' in the upper pg_description des on the des.objoid = t.oid WHERE T. Type! = 'D' and T. Typename e '\\ _%' and t.typnamespace = 3278632 :: not od and whistle. T.T.P. Name  
by IIS Tull Order

Comments