Inheritance clarification please - Mailing list pgsql-general

From tom
Subject Inheritance clarification please
Date
Msg-id 000001c0e206$e346c100$660e2c81@bellsouth.net
Whole thread Raw
Responses Re: Inheritance clarification please
List pgsql-general
Greets,
    I'm trying to get my head around what the benefits to inheritance are.

    Is the data duplicated or just referenced in the parent table? If it's
duplicated then the database size and bloat are an issue for me.

    Another question I have is that say I have a parent table users and a child
table hobbies...one of my users exists only in the users table but now I
want to add his hobbies...is it possible to change him over to the hobbies
table without deleting him in the user table, then inserting him into the
hobbies table from scratch?


pgsql-general by date:

Previous
From: Frank Bax
Date:
Subject: psql shell problem
Next
From: Frank Miles
Date:
Subject: LIKE erratic? or unseen DB corruption?