Re: TRUNCATE VIEW - Mailing list pgsql-docs

From harisai hari
Subject Re: TRUNCATE VIEW
Date
Msg-id CAEUO9HBg=G0--ySsG1R1cjJZkq-WALCHEDBhuac_r_=DyqRxJA@mail.gmail.com
Whole thread Raw
In response to Re: TRUNCATE VIEW  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: TRUNCATE VIEW  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-docs
Could you please provide documentation link, I couldn't find it.

On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Mon, 2021-01-25 at 12:06 +0000, PG Doc comments form wrote:
> In this link https://www.postgresql.org/docs/12/ddl-priv.html you mentioned
> like Truncate of view, Is it possible?
>
> TRUNCATE
> Allows TRUNCATE on a table, view, etc.

Yes, if you define an INSTEAD OF TRUNCATE trigger on the view.

Yours,
Laurenz Albe

pgsql-docs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: TRUNCATE VIEW
Next
From: Laurenz Albe
Date:
Subject: Re: TRUNCATE VIEW