Re: [GENERAL] inherit table and its data

2008-11-21 Thread Christian Schröder
Dilyan Berkovski wrote: 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. PostgreSQL's inheritance works the other way around: If table B inh

[GENERAL] inherit table and its data

2008-11-17 Thread Dilyan Berkovski
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 inse