inherit table and its data

From: Dilyan Berkovski <berkovski(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: inherit table and its data
Date: 2008-11-18 07:22:04
Message-ID: 644082.4132.qm@web33104.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 not possible without triggers.

thanks, Dilyan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-11-18 08:02:31 Re: pgsql-general@postgresql.org
Previous Message Tony Caduto 2008-11-18 06:46:59 Libpq.dll lite is here :-)