! conda install psycopg2

import psycopg2

hostname = 'localhost'
username = 'scrapy_user'
password = '123456' # your password
database = 'scrapy_db'
connection = psycopg2.connect(host=hostname, user=username, password=password, dbname=database)
cursor = connection.cursor()

cursor.execute("select id from table_name ;")

connection.commit()

cursor.close()
connection.close()