BUG: Postgres migration script generates a few syntax errors

Context: I was running migrations with drizzle-kit's migration function from node-postgres , and kept getting a lot of errors.

I had to make the following changes to the SQL script:
  1. Add double quotes around table, index, and other field names
  2. Array fields with default values just never generated the right code. So I had to manually add the default value in.
Screenshots show the full picture
Screen_Shot_2023-03-28_at_11.59.37_PM.png
Was this page helpful?