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.
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.
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
