Supertypes?

I believe you are talking about inheritance which Postgres does support. I
suggest the User's Manual for the details.

len

-----Original Message-----
From: Christian Marschalek <cm@chello.at>
To: [GENERAL] PostgreSQL <pgsql-general@postgresql.org>
Date: Tuesday, March 27, 2001 7:08 AM
Subject: [GENERAL] Supertypes?

Guess it's inheritance.. Quite the same as it is in C++

Well no big deal if pg does not support it. It's just because we learned
some rules about data redundancy :o)

Thanks!

Pg DOES support it!

Oh... My fault :o)

However, it doesn't really have anything
to do with data redundancy. Data redundancy means storing
the same DATA in more than one table meaning that if it
changes in one table, you have to update all of the other
tables. That's not the same as inheritance which means you
can use a common base_table with additions to child tables as
necessary.

Well we've learned that when you have lets say five tables which all
contain name, adresse, city and so on you also have a form of
redundancy... Can be wrong, though ;o)

chris

Hi !

One of our customers has an MS Access DB (I think..)

He sent me a .mdb file.

Does anyone knows a way to convert this to postgreSQL db ?

thank you !
----------------------------------------------------------------
EuroVox
4, place F�lix Eboue
75583 Paris Cedex 12
Tel : 01 44 67 05 05
Fax : 01 44 67 05 19
Web : http://www.eurovox.fr
----------------------------------------------------------------

You can use some conversion tools that can be found on www.greatbridge.org

I've used PgAdmin (windows only) to convert MS Access files to PostgreSQL.

Poul L. Christiansen

On Tue, 27 Mar 2001, Jean-Arthur Silve wrote:

On Tue, Mar 27, 2001 at 03:58:39PM +0200, Christian Marschalek wrote:

Pg DOES support it!

Oh... My fault :o)

However, it doesn't really have anything
to do with data redundancy. Data redundancy means storing
the same DATA in more than one table meaning that if it
changes in one table, you have to update all of the other
tables. That's not the same as inheritance which means you
can use a common base_table with additions to child tables as
necessary.

Well we've learned that when you have lets say five tables which all
contain name, adresse, city and so on you also have a form of
redundancy... Can be wrong, though ;o)

there's also this construct -- i don't know the name --
exemplified below by using the table ADDR (very u.s.centric, i
know) as a DATATYPE in table PERSON:

create table addr(
street varchar(30),
city varchar(30),
state char(2),
zip char(5)
);
create table person(
loc addr, -- how about them apples?
phone char(10),
name varchar(30)
);
\d person
Table "person"
Attribute | Type | Modifier
-----------+-------------+----------
loc | addr |
phone | char(10) |
name | varchar(30) |

the trick, is, how do you insert data into person.addr?

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Oh yeah we've learned about the normal forms too :) It's all flying back
into my mind right now ;o)

Thx!

I believe that what you are looking for is
inheritance.

http://postgresql.readysetnet.com/devel-corner/docs/user/inherit.html

I hope this is helpful,
Jason Earl

--- Christian Marschalek <cm@chello.at> wrote:

In school we've learned about supertypes. I don't
know if the raw
translation is correct so here is an example:
Supertype human with the attributes name,age,size.
Now I can derrive types from it... For example ->
employe with even more
attributes like personal id.

Can I realise this in PostgreSQL? And if yes, would
anybody please
explain how, or point me to the right documentation?

Thanks and regards, Christian Marschalek

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text