Horton

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

Andrew Dunstan <andrew@dunslane.net>

View thread View on postgr.es
From: Andrew Dunstan <andrew@dunslane.net>
To: "David G. Johnston" <david.g.johnston@gmail.com>
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-29T20:01:53Z
Lists: pgsql-hackers 
On 2025-03-29 Sa 2:58 PM, David G. Johnston wrote:
> 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?
>
>

In principle I think it would be good to have COPY materialized_view TO ...


cheers


andrew


--
Andrew Dunstan
EDB:https://www.enterprisedb.com

Commits

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