Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> writes:
> I was wondering what the community thought of using table inheritance in PostgreSQL? Is it considered bad practice these days?
Mmm ... not if the various caveats[1] don't bother you. The biggest
stumbling block for most people, I think, is that you can't have
foreign keys that reference the whole inheritance hierarchy.
regards, tom lane
[1] https://www.postgresql.org/docs/current/ddl-inherit.html#DDL-INHERIT-CAVEATS