I am not an expert for database but rarely design database for Web and IVR
Today I wonder if there is any practical advantage of inheritance of Tables.
Lets take the same example that is commonly referred.
CREATE TABLE cities (
altitude int -- in feet
CREATE TABLE capitals (
) INHERITS (cities);
Capital table inherit attributes from Cities but no data. I am
confused with concept of inheritance in postgres.
In These tables what i was supposing is inheritence as that in JAVA. but its
seems to be a different scene.
Can some one Please compare inheritence in JAVA and Postgresql OR make me
clear about for what inheritance is introduced in Postgres.
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2009-12-16 06:51:56|
|Subject: Re: Inheritance in Postgresql ?|
|Previous:||From: Gurjeet Singh||Date: 2009-12-16 05:18:45|
|Subject: Re: Internal fragmentations statistics Was: VACUUM FULL memory requirements|