On 1/2/20 5:47 AM, Tom Lane wrote: > Sonam Sharma <sonams1209@gmail.com> 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.)
Caffeine kicked in, now I remember how the above happens: