Re: psql - prompt for password

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

Hi Edwin

You can use \prompt for this reason, following is the example.

You first use the \prompt to get the password and store into a variable

You can then user CREATE USER Command and supply the variable used with \prompt to provide the password.

I hope this helps.

=# \prompt 'Enter password for new user: ' new_user_password
Enter password for new user: test
# CREATE USER spongebob WITH ENCRYPTED PASSWORD :'new_user_password';
CREATE ROLE

Regards

Kashif Zeeshan

Bitnine Global

On Thu, May 30, 2024 at 1:07 PM Edwin UY <edwin.uy@xxxxxxxxx> wrote:

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