On Tue, Oct 6, 2020 at 2:59 PM Ian Lawrence Barwick <barwick@gmail.com> wrote:
Hi
Recently I ran into a case where someone was wondering why it was not possible to dump the contents of a view, even though the documentation [1] seems to imply this is possible.
Currently it says:
Dump only tables with names matching pattern. For this purpose, "table" includes views, materialized views, sequences, and foreign tables.
The attached patch attempts to clarify that only definitions of those objects will be dumped, and also mentions that dumping foreign table data requires the --include-foreign-data option.
I suggest backpatching any changes to Pg13 where the --include-foreign-data option was added.