Re: psql - prompt for password

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