Databases
python code for interacting with db
Last updated
Was this helpful?
python code for interacting with db
Last updated
Was this helpful?
Was this helpful?
Installation
pip install psycopg2
Establishing connection
​
import psycopg2 try: connection = psycopg2.connect(DATABASE_URL) cursor = connection.cursor()
# Print PostgreSQL Connection properties
print ( connection.get_dsn_parameters(),"\n")
# Print PostgreSQL version
cursor.execute("SELECT version();")
record = cursor.fetchone()
print("You are connected to - ", record,"\n")
except (Exception, psycopg2.Error) as error : print ("Error while connecting to PostgreSQL", error) finally:
#closing database connection.
if(connection):
cursor.close()
connection.close()
print("PostgreSQL connection is closed")
​```
```