Missing support for INHERITS

[ian-weir]

When using the INHERITS functionality in a database the generated types to not reflect this inheritence. Using the example from the Postgresql documentation:

CREATE TABLE cities (
    name            text,
    population      float,
    elevation       int     -- in feet
);

CREATE TABLE capitals (
    state           char(2)
) INHERITS (cities);

Kanel would output something like:

//Cities.ts
export default interface Cities {
  name: string;
  population: number;
  elevation: number;
}

//Capitals.ts
export default interface Capitals {
  state: string;
}

Which doesn't correctly represent the model of the database. The correct output would look like:

//Capitals.ts
export default interface Capitals extends Cities {
  state: string;
}

I really like the rest of the way Kanel behaves but this is sadly a blocker from me using it at work :(

[kristiandupont]

Ah yes, I can see that this is a missing feature. I will need to add support for inheritance to extract-pg-schema for this to be possible.