Locally hosted password change

[Erin]

I have followed the postgres steps for password reset on a locally hosted version but when I run the sql query:
UPDATE public.user SET password=‘HASH_PASSWORD’ WHERE email=‘YOUR_EMAIL_ADDRESS’;

I get the error message relation “public.user” does not exist, what may be the issue?

Also the user table clearly exists because if i go to the postgres shell and type \c activepieces then \dt+ I see it

[startuphosting2015]

@Erin

UPDATE public.user SET password=‘HASH_PASSWORD’ WHERE email=‘YOUR_EMAIL_ADDRESS’;

remove the public. part and just have it as
UPDATE user SET…