issac
issac
DTDrizzle Team
Created by issac on 3/11/2024 in #help
daterange postgres column type handled as unknown
What to do?help needed. I was to create a events table in which i also have to store multi day spanning events too, so that i thought daterange type of postgres meets my requirement for storing such data, i found out it is not what druzzle orm supports, so as a hack i first run create command for that table in postgres client cli, and then run introspection command in drizzle. Now, it shows unknown("dateRange") in the schema. If i do something with this table like inset, it will point error to unknown type. What might be the best solution for this besides giving up and creating two columns like start date and end date in that table.
1 replies