Re: TRUNCATE VIEW - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: TRUNCATE VIEW
Date
Msg-id 4d8ee45bb0d07a09da5d64d6cba114e7db5777b3.camel@cybertec.at
Whole thread Raw
In response to TRUNCATE VIEW  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: TRUNCATE VIEW  (harisai hari <harisai.58@gmail.com>)
List pgsql-docs
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: PG Doc comments form
Date:
Subject: TRUNCATE VIEW
Next
From: harisai hari
Date:
Subject: Re: TRUNCATE VIEW