PGError: Error: column of relation does not exist PGError: Error: column of relation does not exist postgresql postgresql

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 ....