Administrator password reset using Postgres - help needed!

Hi,

I need to reset the administrator password for SCP (this is the only admin rights profile we have), using the instructions for postgres:

For PostgreSQL :

Follow the steps given below which will help you to reset the "admin /administrator" password as "admin".

Connect to PostgreSQL Server on Port 65432 from the SupportCenter Plus server.

Use the following query to reset the password

postgres# update AaaPassword join AaaAccPassword on AaaPassword.password_id = AaaAccPassword.password_id join AaaAccount on AaaAccPassword.account_id = AaaAccount.account_id join AaaLogin on AaaAccount.login_id = AaaLogin.login_id set PASSWORD='2+uYvE3SLfO3XaHl+CaGLA==', SALT='1103287238602' where name like 'admin%';

Can you confirm that the syntax is correct as the I am getting errors in the first "join".

I need to reset asap so any assistance would be greatly appreciated.

Many thanks,

Lucy.