Robert Staudinger writes:
> I'm planning to build some kind of simple object oriented database and
> came across PostgreSQL because of it's nearly unlimited ways of
> The documentation is really good an I learned a lot about composite
> datatypes, how to program them in c, create indices ... from the "Server
> Programming" section of the "Developer Manual".
> The problem in my case is that I don't know the names of the attributes
> beforehand so I can't do a table bases mapping with one table for each
> type of object ("class"). So I thought It would maybe be possible to
> store the objects always in the same composed datatype - with "dynamic
> member fields".
I use inheritance in such a case.
(see INHERITS in CREATE TABLE)
Table with common columns as a base class
and different tables for classes with
inherited base class.
Multiple and multilevel inheritanse possible.
> Ok this may be completely insane but ...
> Maybe you could just tell me if it's worth to dig deeper.
> Robert Staudinger
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
In response to
pgsql-interfaces by date
|Next:||From: Peter Eisentraut||Date: 2002-05-10 21:24:40|
|Subject: Re: internal voting|
|Previous:||From: Jim Bowery||Date: 2002-05-10 16:07:38|
|Subject: dbconnect Argument Format?|