multipe Connections Servers/database postgres with python

Asked

Viewed 4 times

0

I am a student python basic language yet and I would like to Learn how to connect in multiples Servers and database postgresql through sql query. I have 9 Servers and 200 Databases with same Structure Tables (1000) between . I would like to find way iterate over them like it:

read csv file (separator ',' with the structute: server_name, db_name, port) create Dinamic Connection read sql query (eg: select * from xxx) record the db_name after Doing all the iterations with the query, Return the data to a table in postgres by Adding the db_name as a column

Thanks guys

  • Please clarify your problem or provide additional details in order to highlight exactly what you need. The way it’s written these days it’s hard to tell exactly what you’re asking.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.