Horton

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

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

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Kirill Reshke <reshkekirill@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, 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-29T19:49:16Z
Lists: pgsql-hackers 
On Sat, Mar 29, 2025 at 12:27 PM Kirill Reshke <reshkekirill@gmail.com>
wrote:

> On Sat, 29 Mar 2025 at 19:59, David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> > Regardless, I do support this patch and probably any similar ones
> proposed in the future.  Do you have an opinion on that?
> >
>
> I do also support what this patch aims to do, how do you like v1?
>
>
Seems reasonable, but I don't have enough experience with the codebase in
that area to submit a code review or be aware of any unexpected
side-effects or deficiencies.

David J.

Commits

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