Re: Inheritance and views - Mailing list pgsql-general

From Eric G. Miller
Subject Re: Inheritance and views
Date
Msg-id 20010404181614.A23460@calico.local
Whole thread Raw
In response to Inheritance and views  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
On Wed, Apr 04, 2001 at 02:07:13PM +0200, DaVinci wrote:
>  Hello.
>
>  I'd like to implement for my DB a mechanism of backup based in inherited
>  tables. I explain it in detail:
>
>  Idea is simple: table B inherits from table A. Anualy, data from table A is
>  dumped in B. So, from frontend it is posible to access current data (from
>  A) or all data (A + B).
>
>  Problem is that I'd like also implement a view for A and B, but I don't
>  know what is best way. View(s) must have rules for insert and update. Can
>  view from A access data from B without problem (eliminating "ONLY" from
>  select)?. Is there another better form of implementing this backup
>  mechanism?. I'd not want to reinvent the wheel ;)
>
>  Thanks for your ideas.

Maybe...

SELECT * FROM A* ;

Notice the asterisk on the superclass table name.

--
Eric G. Miller <egm2@jps.net>

pgsql-general by date:

Previous
From: "Norman J. Clarke"
Date:
Subject: Re: JBuilder4 JDBC Explorer
Next
From: "John Menke"
Date:
Subject: RE: JBuilder4 JDBC Explorer