From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | [doc] clarify behaviour of pg_dump's -t/--table option with non-tables |
Date: | 2020-10-06 12:58:51 |
Message-ID: | CAB8KJ=hmzQH6rMb9uk-8sDmFkPXjRcfNpefVRqvFEeBwxVAVrg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
[1] https://www.postgresql.org/docs/current/app-pgdump.html
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
doc-pg_dump-clarify-table-option.patch | text/x-patch | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bharath Rupireddy | 2020-10-06 13:06:34 | Re: Logical Replication - detail message with names of missing columns |
Previous Message | Magnus Hagander | 2020-10-06 12:56:51 | Re: Prevent printing "next step instructions" in initdb and pg_upgrade |