Postgres UPDATE

Question

I have been locked out of cacti after setting guest_user=admin :( So I am trying to recover my access

cacti=# select * from settings;
           name            | value
-------------------------------------------
 auth_method               | 1
 guest_user                | admin

When I try to run the query:

UPDATE settings SET guest_user = 'No User' WHERE guest_user = 'admin';

I get the error:

cacti=# UPDATE settings SET guest_user = 'No User' WHERE guest_user = 'admin';
ERROR:  column "guest_user" does not exist
LINE 1: UPDATE settings SET guest_user = 'No User' WHERE guest_user ...

Database is postgres and I am new to it. (its the first time I use it :-) )

try UPDATE settings SET value = 'No User' WHERE name = 'guest_user'; because the column names are name and value, — fvu
– fvu, Commented Jul 7, 2012 at 23:32
@fvu: You should post that as an answer so it can be accepted. — Jonathan Hall
– Jonathan Hall, Commented Jul 8, 2012 at 19:55

fvu · Accepted Answer · 2012-07-08 20:50:03Z

13

Try

UPDATE settings SET value = 'No User' WHERE name = 'guest_user';

because the column names are name and value

answered Jul 8, 2012 at 20:50

fvu

33.1k6 gold badges64 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres UPDATE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related