Re: Weird quirk with pg_dump of complex types - Mailing list pgsql-bugs

Josh Berkus <josh@agliodbs.com> writes:
> When doing pg_dump in text mode, complext types will be dumped like this:

> CREATE TYPE complex_foo (
>     var    INT,
>     gar    TEXT,
>     natch    public.foo_type
> );

You didn't say which schema "complex_foo" is in?

> That is, a custom type in a complex type declaration is explicitly
> schema-qualified, even when the schema in question is in the default
> schema_path.

There is no such thing as a default search path for pg_dump's purposes.

            regards, tom lane