Re: Schema dump

Sonam Sharma <[email protected]> writes:
> I took a schema dump using : pg_dump -n schema dbname .
> When I restored this , it doesn't contain the constraints and indexes. Can
> someone please help how to take a dump including all

Hmph ... works for me.  Where by "works", I mean "the dump contains
constraints and indexes belonging to tables in the specified schema,
and not any others".  Maybe you could provide a little more detail?

(One thing I notice is that the dump doesn't contain a "CREATE
SCHEMA schema" command, so you have to do that manually before
you restore.  I guess this fits with the definition of the switch
as selecting objects *in* the named schema, but it's still a
possible gotcha.)

			regards, tom lane