From: | Mike Frisch <mfrisch(at)saturn(dot)tlug(dot)org> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Help with views... |
Date: | 1999-06-03 01:11:47 |
Message-ID: | Pine.LNX.4.10.9906022106350.31396-100000@gateway.saturn.tlug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)saturn(dot)tlug(dot)org
Northstar Technologies WWW: http://saturn.tlug.org/~mfrisch
Newmarket, Ontario, CANADA
======================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Frisch | 1999-06-03 01:20:19 | Correct use of views |
Previous Message | Chris Bitmead | 1999-06-03 00:38:25 | Re: [GENERAL] powered by postgresql |