Обсуждение: Help with views...

Поиск
Список
Период
Сортировка

Help with views...

От
Mike Frisch
Дата:
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
======================================================================