Sridhar N Bamandlapally <sridhar.bn1@gmail.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