How to enter the requested data in the terminal

Asked Feb 08 '23 at 17:29

Active Feb 08 '23 at 17:29

Viewed 29 times

I had a problem entering the password directly through the python program

When I do something in PostgreSQL, it asks for a database password and here

How can I enter the database password through python so that it is entered in the requested field

pg_dump.exe -U dbuser -h localhost dbname >> s.sql
>>>Password:

I know that there is a .pgpass file, but there is a possibility of frequent password changes

asked Feb 08 '23 at 17:29

Qadyr Israfilov

have you tried `echo password | pg_dump.exe -U dbuser -h localhost dbname >> s.sql` ? – azro Feb 08 '23 at 17:30
@azro it still asks for password – Qadyr Israfilov Feb 08 '23 at 17:33
Did you look at [How to pass in password to pg_dump?](https://stackoverflow.com/questions/2893954/how-to-pass-in-password-to-pg-dump) ? – Maurice Meyer Feb 08 '23 at 17:34
4

I don't understand yet what this has to do with Python. – mkrieger1 Feb 08 '23 at 17:37
@mkrieger1 I entered the postgresql command as an example to make it clear where I want to enter the value using python – Qadyr Israfilov Feb 08 '23 at 18:54

0 Answers0