postgresql7.1 SELECT t.typname, n.nspname, t.typnotnull, t.typdefault, pg_catalog.format_type(t.typbasetype, t.typtypmod), pg_catalog.pg_get_userbyid(t.typowner) FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE t.typtype = 'd' AND pg_catalog.pg_type_is_visible(t.oid) [template::list::orderby_clause -name domains -orderby] SELECT t.typname, n.nspname, t.typnotnull, t.typdefault, pg_catalog.format_type(t.typbasetype, t.typtypmod), pg_catalog.pg_get_userbyid(t.typowner) FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE t.typtype = 'd' AND pg_catalog.pg_type_is_visible(t.oid) and [template::list::page_where_clause -name domains] [template::list::orderby_clause -name domains -orderby]