[doc] clarify behaviour of pg_dump's -t/--table option with non-tables

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

Responses

Browse pgsql-hackers by date

  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