PostgreSQL columns with custom enum types are not being derived.

[antonklimov]

The columns which have enum type in Postgres like CREATE TYPE t1 as ENUM ('V1', 'V2') do not appear in the generated schemas.

[tareqimbasher]

@antonklimov can you please provide a SQL script to reproduce the issue?

[antonklimov]

@tareqimbasher

CREATE TYPE t1 as ENUM ('V1', 'V2');
CREATE TABLE test1 (
    id int,
    enum_column t1

);
INSERT INTO test1 values (1, 'V1');
SELECT * FROM test1;

[tareqimbasher]

Update: It looks like EF Core's scaffolding tool skips ENUM type columns and does not generate CLR properties for them. Since NetPad uses the same EF Core tooling to scaffold your database, it will have the same limitations. I will keep this ticket open however as I believe we could still find a solution around this.