PGError: Error: column of relation does not exist
If you are sure that column isGroup
exists, then you should quote it like:
UPDATE posts SET "isGroup" = 'public'
Note that PostgreSQL by default folds all unquoted named to lowercase.
To avoid this confusion and necessity to quote, you might want to rename isGroup
to isgroup
using ALTER TABLE ... RENAME COLUMN ...
.