Correct use of views
От | Mike Frisch |
---|---|
Тема | Correct use of views |
Дата | |
Msg-id | Pine.LNX.4.10.9906022120000.31396-100000@gateway.saturn.tlug.org обсуждение исходный текст |
Список | pgsql-general |
I have a large PostgreSQL database from which I would like to work on a subset of the data through SQL VIEWs. Since the number of views that may be valid at any given time can possibly be quite large (on the magnitude of 100s or possibly 1000s), I am curious to know if there's an imposed limit on the number of views in PostgreSQL? Given the fact that there may be an arbitrary (possibly large) number of views, what is the best way to determine if a view does not already exist? If it doesn't exist the first time it's called upon, I would like to create it (no problem there). Thanks in advance, Mike. ====================================================================== Mike Frisch Email: mfrisch@saturn.tlug.org Northstar Technologies WWW: http://saturn.tlug.org/~mfrisch Newmarket, Ontario, CANADA ======================================================================
В списке pgsql-general по дате отправления: