You can run your query by psycopg2 that is widely used to use Postgresql database in Python

The code is for connecting to a PostgreSQL database and fetching the result of a query using the Python psycopg2 library:

import psycopg2

# Establish a connection to the database
conn = psycopg2.connect(
    host="host",
    database="database",
    user="user",
    password="password"
)

# Create a cursor object to execute queries
cur = conn.cursor()

# Execute a query to retrieve data
query = "SELECT * FROM table_name"
cur.execute(query)

# Fetch all the rows of the result
rows = cur.fetchall()

# Loop through the rows and print the data
for row in rows:
    print(row)

# Clean up
cur.close()
conn.close()