>-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of rasoolbv >Sent: Thursday, 14 February 2008 6:42 >To: pgadmin-support@postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
