From: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
---|---|
To: | "rasoolbv" <rasoolbv(at)yahoo(dot)com(dot)sg> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Creating table as datatype |
Date: | 2008-02-14 12:57:43 |
Message-ID: | E4953B65D9E5054AA6C227B410C56AA9C357@exchange1.joris2k.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
>-----Original Message-----
>From: pgadmin-support-owner(at)postgresql(dot)org
>[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of rasoolbv
>Sent: Thursday, 14 February 2008 6:42
>To: pgadmin-support(at)postgresql(dot)org
>Subject: [pgadmin-support] Creating table as datatype
>
>
>Hi, I am new to this ordb, postgresql and pgadmin. I am using
>this for a project that involves lots of object aggregation
>and inheritance.
Look for documents about the Relation model and normalization.
For example: <http://en.wikipedia.org/wiki/Database_normalization>
Others might have very good links, search the archives and the archives
of the postgresql-general mailing list.
Inheritance is a quite hard subject in the relational model and opinions
on whether and how to use here may vary quite a lot. Personally I think
it can give quite a few problems and you should use it very sparingly.
Use other means to archieve the same result.
>Currently I am able to create a column as of datatype. That
>is, for a staff I can have a multivalued column of datatype
>internalAddress. I want to create a table of a datatype. That
>is for instance, a table of datatype staff and this is later
>to be part of a company. I don't seem to find this option
>available. Hope to get some help in this.
Your paradigms are closely related to Object-Oriented programming. The
relational model is slightly different.
You need to see your database types more as tables or relations (note:
table and relation have the same meaning, the naming might be confusing,
but it has it roots in mathematics (logic and set theory) and the other
more in computer science).
- Joris
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2008-02-15 08:30:44 | Compiling PgAdmin 1.8.x on Debian Lenny AMD64 ? |
Previous Message | rasoolbv | 2008-02-14 05:41:44 | Creating table as datatype |