PostgreSQL domains: INTEGER column (via DOMAIN definition) is mapped to string

[mperdikeas]

I have a column in PostgreSQL:

person_type: INTEGER

This is mapped to a JavaScript number | null just as it should be.

If instead, the column is defined via a PostgreSQL domain that is itself simply an alias for INTEGER, or INT4 like so:

CREATE DOMAIN FOREIGN_KEY AS INTEGER
...
person_type: FOREIGN_KEY

Then it is mapped as string | null. In fact this behavior remains even if the domain is aliased to SMALLINT

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.