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.