On 6/11/08, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Rajesh Chopra wrote: > > Hi, > > I created a new type as follows: > > CREATE TYPE compfoo AS (f1 int, f2 text); > > > > Now I need the DDL which postgres used to create this type. > > > > Huh, what do you mean? That CREATE TYPE statement is DDL.
I think what the OP was asking was how to reverse engineer the DDL out of the database for an already created type (but you're right, this is not a bug). in psql, the create type source sql is not displayed like it is for views for example. There are a couple of ways to do this: *) pg_dump -s and examine the output *) fire up pgadmin, browse types folder-- pgadmin shows source ddl for all database objects Also, composite types (CREATE TYPE AS), are trivially reverse engineered from the column lists. Non composite types are a little more complicated. side thought -- it would be nice for pg_restore to be able to extract more specific objects out of the custom format dump than what it currently allows...types for example. merlin -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
