Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general