CODEWITHSUNDEEP
sqlpostgresqlherokurails-postgresql
justewe3
justewe3

Reputation: 73

update query not working on Heroku using cloud 9 command line

I have the following tables:

enter image description here

and the users table contains the following columns:

enter image description here

I am trying to run the following statement:

UPDATE users SET isTeacher = 'TRUE' WHERE id = '2';

but I am getting the following error message:

ERROR:  column "isteacher" of relation "users" does not exist
LINE 1: UPDATE users SET isTeacher = 'TRUE' WHERE id = '2';
                         ^

Please not that there is a user with id of 2. So What am I doing wrong ?

Thanks for your time

Upvotes: 1

Views: 123

Answers (1)

Jocker_mix
Jocker_mix

Reputation: 80

I had once the same problem. I think the problem is that u have it as isTeacher. u need to convert it to isteacher or is_teacher. I hope that helped. check this link: PostgreSQL naming conventions

Upvotes: 1

Related Questions