Am 30.05.24 um 10:07 schrieb Edwin UY:
Hi,Is createuser the only one I can use to create a user where it prompts for a password? There is no alteruser though.I want to use psql and \prompt but am lost on how to use it.Basically just want to use it for running a psql script like for example - ALTER USER spongebob WITH ENCRYPTED PASSWORD ':newpassword';Regards, Ed
You can feed a command into psql for that. Example: echo "alter user spongebob password 'secret2'" | psql Add arguments for psql, like -U -d -h -p as needed. Regards, Holger -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
