same record in two inherited postgres tables

Question

I've got an old system that uses postgres table inheritance and I don't know much about it, but I have this situation:

there's three tables: "person", "student" and "teacher"

both "student" and "teacher" inherit from "person".

Now, I have a student who became a teacher and I need to save him in both tables. Is this even possible?

Dudaskank · Accepted Answer · 2013-09-06 18:08:52Z

1

Yes, it's possible. You will have three inserts, one for eache table you want.

insert into person ...
insert into student ...
insert into teacher ...

answered Sep 6, 2013 at 18:08

Dudaskank

3084 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, this wasn't working at first because I tried to suppress the repeated data.