Re: pg_dump does not dump tables created in information_schema schema

2021-10-07 Thread vignesh C
On Thu, Oct 7, 2021 at 9:30 PM Tom Lane wrote: > > "David G. Johnston" writes: > > On Thursday, October 7, 2021, vignesh C wrote: > >> Should tables be allowed to create in "information_schema" schema, if > >> yes should the tables/publications be dumped while dumping database > >> contents? > >

Re: pg_dump does not dump tables created in information_schema schema

2021-10-07 Thread Tom Lane
"David G. Johnston" writes: > On Thursday, October 7, 2021, vignesh C wrote: >> Should tables be allowed to create in "information_schema" schema, if >> yes should the tables/publications be dumped while dumping database >> contents? > I presume you have to be superuser to do this. If so, this

Re: pg_dump does not dump tables created in information_schema schema

2021-10-07 Thread David G. Johnston
On Thursday, October 7, 2021, vignesh C wrote: > > Should tables be allowed to create in "information_schema" schema, if > yes should the tables/publications be dumped while dumping database > contents? > > I presume you have to be superuser to do this. If so, this would seem to fit under the “w