Help with views...

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
======================================================================

Browse pgsql-general by date

  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