Horton

Re: TRUNCATE VIEW

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: harisai.58@gmail.com, pgsql-docs@lists.postgresql.org
Date: 2021-01-25T12:38:52Z
Lists: 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

Commits

  1. doc: Remove reference to views for TRUNCATE privilege