Thanks Adrian, it worked :) On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 1/2/20 5:47 AM, Tom Lane wrote: > > Sonam Sharma <sonams1...@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: > > pg_restore -n utility -f pgrestore_utility.sql /production_12.out > > In pgrestore_utility.sql there is no CREATE SCHEMA. > > This came up in a previous thread: > > https://www.postgresql.org/message-id/6234.1569941612%40sss.pgh.pa.us > > > > > regards, tom lane > > > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >