Re: Rules on View

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rules on View
Date: 2016-03-01 15:07:39
Message-ID: 10356.1456844859@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> writes:
> Is there a way to avoid creating rule under creation of view ?

If you mean the ON SELECT rule, no. A view basically *is* an ON SELECT
rule; there's not very much else to it. What usefulness do you imagine
you'd get from a view without ON SELECT?

regards, tom lane

In response to

  • Rules on View at 2016-03-01 10:07:13 from Sridhar N Bamandlapally

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2016-03-01 18:41:46 Does RAISE EXCEPTION rollback previous commands in a stored function?
Previous Message pbj 2016-03-01 15:03:05 Re: Anyone compare PG 9.5 and MongoDB 3.2?