| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | jian he <jian(dot)universality(at)gmail(dot)com>, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: slightly confusing "contents of views" |
| Date: | 2026-08-12 11:58:26 |
| Message-ID: | 29a6e249-d919-41eb-975b-06d433258801@eisentraut.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On 12.08.26 06:39, jian he wrote:
> https://www.postgresql.org/docs/devel/app-pgdump.html
> <<>>
> As well as tables, this option can be used to dump the definition of
> matching views, materialized views, foreign tables, and sequences. It
> will not dump the contents of views or materialized views, and the
> contents of foreign tables will only be dumped if the corresponding
> foreign server is specified with --include-foreign-data.
> <<>>
>
> Views don't have content, the preceding sentence already mentioned we
> will dump the definition of views.
>
> So we can change
> ``It will not dump the contents of views or materialized views,``
> to
> ``It will not dump the contents of materialized views,``
Views have content in a way. It is computed on the fly. One could
imagine a pg_dump feature that dumps out view content like a table (with
COPY or INSERT commands) and allows restoring it. I think it's not
redundant to clarify that this does not happen.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keisuke Kuroda | 2026-08-14 06:13:40 | Doc: Fix description of %L escape in PostgreSQL 18 release notes |
| Previous Message | jian he | 2026-08-12 04:39:13 | slightly confusing "contents of views" |