Peter Harvey wrote:
>Yes. But pgsql does not support multiple inheritance (from what I can
>tell)...
In fact it does:
create table child (col1 text) inherits (parent1, parent2);
Identically named and typed columns in the parents are merged.
--
Oliver Elphick
Peter Harvey wrote:
>
> Anyone know how inherited tables are shown on an ERD... both the table
> and the connector (if any)?
>
> What I am looking for is how to draw this in the diagram.
An old S-Designor does it so:
---(end of broadcast)---
TI
Anyone know how inherited tables are shown on an ERD... both the table
and the connector (if any)?
What I am looking for is how to draw this in the diagram.
Peter
--
+---
| Data Architect
| your data; how you want it
| http://www.codebydesign.com
+--
