Support for ENUMs about sql-ts HOT 6 CLOSED

ENUM support for Postgres has been added to 1.5.0. I don't have a lot of experience with Postgres but I've think I got it working. If you reference an ENUM in a different schema or if multiple exist with the same name, use the schemaAsNamespace config option.

I may implement MySQL ENUMs as string unions as was suggested in the original ticket if there's more interest.

from sql-ts.

It's something I've wanted to implement for a while. PostgreSQL and MySQL can be done with enums, the single use MySQL enums aren't great but they still work. The PostgreSQL naming can come from the definition, MySQL would have to be {table}{column}Enum or something similar.

The way I use enums in other dbs is by using a table as the enum definition. The primary key becomes the value and another column becomes the key. Any column that foreign keys to this table becomes an enum. I didn't know how widespread this is which is why it was never included.

from sql-ts.

Hey @rmp135, have you given any more thought to supporting this?

from sql-ts.

I can take another look. Are you looking for support for a specific database engine?

from sql-ts.

Yeah, I am specifically targeting Postgres. How much work do you think this would take?

from sql-ts.

Awesome. Thanks alot!

from sql-ts.