Re: Schema dump

Sonam Sharma 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 in

Re: Schema dump

On 1/2/20 5:47 AM, Tom Lane wrote: Sonam Sharma 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

Re: Schema dump

On 1/2/20 5:47 AM, Tom Lane wrote: Sonam Sharma 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

Re: Schema dump

Thanks Adrian, it worked :) On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver wrote: > On 1/2/20 5:47 AM, Tom Lane wrote: > > Sonam Sharma 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

Re: Schema dump

On 1/2/20 9:04 AM, Sonam Sharma wrote: Thanks Adrian, it worked :) What worked? Still not clear what was not working in the first place? On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver > wrote: On 1/2/20 5:47 AM, Tom Lane wrote: > Sonam Sharma mailto: