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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).
Date: 2025-03-29 20:01:53
Message-ID: 425ebe4b-06c5-4212-af68-fd0e5537c250@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)dunslane(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2025-03-29 20:09:56 Re: Using read stream in autoprewarm
Previous Message David G. Johnston 2025-03-29 19:49:16 Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).