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

pg_dump does not dump tables created in information_schema schema

2021-10-07 Thread vignesh C
Hi, I was able to create a table in "information_schema" schema, but pg_dump does not dumps the table that was created in "information_schema" schema: create table information_schema.t1(c1 int); The similar problem exists in case of create publication, we are able to create publications for table