Re: TRUNCATE VIEW

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: harisai(dot)58(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: TRUNCATE VIEW
Date: 2021-01-25 12:38:52
Message-ID: 4d8ee45bb0d07a09da5d64d6cba114e7db5777b3.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message harisai hari 2021-01-25 13:15:23 Re: TRUNCATE VIEW
Previous Message PG Doc comments form 2021-01-25 12:06:08 TRUNCATE VIEW