Postgres Pro
Downloads
Home   >   mailing lists

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

From vignesh C
Subject pg_dump does not dump tables created in information_schema schema
Date
Msg-id CALDaNm3NWpn6oeAGo+SsJ3+n5NMBWAVqF+6+u5y+99+fAFZJoA@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump does not dump tables created in information_schema schema
List pgsql-hackers
Tree view 
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 tables present in "information_schema"
schema, but pg_dump does not dump the publication to include the
information_schema.t1 information.
create publication pub1 for table information_schema.t1;

Should tables be allowed to create in "information_schema" schema, if
yes should the tables/publications be dumped while dumping database
contents?
Thoughts?

Regards,
Vignesh

pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: prevent immature WAL streaming
Next
From: Andrei Zubkov
Date:
Subject: Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements