Re: pg_dump does not dump tables created in information_schema schema - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: pg_dump does not dump tables created in information_schema schema
Date
Msg-id CAKFQuwbi25GvNOHwtA-xUGGbK82h_V2uvZuRuPBTvbBYs+DyKw@mail.gmail.com
Whole thread Raw
In response to pg_dump does not dump tables created in information_schema schema  (vignesh C <vignesh21@gmail.com>)
Responses Re: pg_dump does not dump tables created in information_schema schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thursday, October 7, 2021, vignesh C <vignesh21@gmail.com> 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 “we don’t stop you, but you shouldn’t” advice that we apply throughout the system, like in say modifying stuff in pg_catalog.  Information_schema is an internal schema attached to an static for a given release.

David J.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce)
Next
From: Stephen Frost
Date:
Subject: Re: Role Self-Administration