How to hide password in a Python script when connecting to PostgreSQL?

Question

When connecting to PostgreSQL using Psycopg2 user name and password must be supplied to reach the database. When I'm working in my computer keeping password of my local database as plain text is not a problem.

But when I want to use this script in another computer I need to hide credentials. How this can be done ? Any help appreciated

h.

Does this answer your question? python connect to postgresql with libpq-pgpass — legends2k
– legends2k, Commented Aug 17, 2022 at 7:42

Ben · Accepted Answer · 2018-07-18 15:08:07Z

1

The easiest way to hide credentials is to not store them on the public machine. Use the getpass module to prompt future you for your password.

answered Jul 18, 2018 at 15:08

Ben

6,4834 gold badges38 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Capan Over a year ago

Hi Ben, what if I want to run the script at specific time intervals like a scheduled task ?

Collectives™ on Stack Overflow

How to hide password in a Python script when connecting to PostgreSQL?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related