UPDATE res_users SET password = '123456' WHERE login = 'admin';

In PostgreSQL, to list all fields (columns) of a table named res_users, you can use the following SQL query:

or using psql cmd

\l - list all databases
\connect db_name

\d res_users
SELECT * FROM res_users WHERE login ILIKE '%alicja%';

how to list the column names in a particular table using postgresql command line

SELECT column_name
FROM information_schema.columns
WHERE table_name = 'account_account';