Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Kirill Reshke <reshkekirill@gmail.com>, jian he <jian.universality@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael@paquier.xyz>
Date: 2025-03-29T18:58:22Z
Lists: pgsql-hackers
On Sat, Mar 29, 2025 at 11:56 AM Andrew Dunstan <andrew@dunslane.net> wrote:

> I don't believe that the premise supports the conclusion.
>
>
> Regardless, I do support this patch and probably any similar ones proposed
in the future.  Do you have an opinion on that?

David J.

Commits

  1. Allow "COPY table TO" command to copy rows from materialized views.