inherit table and its data - Mailing list pgsql-general

From Dilyan Berkovski
Subject inherit table and its data
Date
Msg-id 644082.4132.qm@web33104.mail.mud.yahoo.com
Whole thread Raw
Responses Re: inherit table and its data
List pgsql-general
hi All,
I am using PostgreSQL 8.2, and I am interested in creating a table B that inherits table A, but with all it's data!

create table B {a int} inherits A, just adds the structure of table A, not its data.

Is it possible to do this without the classic way - trigger on table A so each insert/update is done also in B, or it's
notpossible without triggers. 

thanks, Dilyan





pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Libpq.dll lite is here :-)
Next
From: "Albe Laurenz"
Date:
Subject: Re: pgsql-general@postgresql.org