You can tell PostgreSQL to map the varchar to the default_calculation_method PostgreSQL enumeration. Run the following on your database: CREATE CAST (varchar AS default_calculation_method) WITH INOUT AS IMPLICIT;