Unable to create a database with a specific engine

[FranciscoJRSantos]

I'm using Clickhouse to replicate a set of PostgreSQL tables. It would come in handy if I could specify the MaterializedPostgreSQL engine on the database.yml file and have it be applied for the Clickhouse database that stores the replicated PostgreSQL tables.

The reason this would be helpful is that I'm having rails create the database in clickhouse but I'd have to drop it at a later point to then create it again with the correct engine.

Is this something you plan to add in the future? If I contributed to the project with the ability to specify the default engine of a database, is that something you'd be interested in reviewing?