bibi92
asked on
create user failed in command line
Hello,
I try to create user with below command
sudo -u postgres psql -c 'CREATE USER svcpg WITH PASSWORD 'test2023' INHERIT;'
ERREUR: erreur de syntaxe sur ou près de « test2023 »
LINE 1: CREATE USER svcpg WITH PASSWORD test2023...
How to resolve it ?
Thank you
Best regards
ASKER
Thank you but I have already try it.
Best regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check your use of quotes You'll need to escape the quotes around the password, or mix single and double quotes for the string and and password.