Hello

I don't understand behaviour of pg_dump when single schema dump option is set. For example my_schema.

With pg_dump -n my_schema it dumps create object definitions without schema in object name. But in the same file, setting attributes to created objects uses schema names.

For example:

CREATE TABLE foo ....
ALTER TABLE my_schema.foo


And finally a question. Is it possible to force/hack pg_dump to add schema to all object names as it does while dumping whole database? it would be useful.

regards