Postgre Database Python operations

1. Python Connect Postgre

Https://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL Using psycopg2 with PostgreSQL

ImportPSYCOPG2ImportPprint
#get a connection, if a connect cannot is made an exception would be raised hereconn = Psycopg2.connect ("dbname= ' db1 ' user= ' postgres ' host= ' localhost ' password= ' 123 '")#Conn.cursor'll return a cursor object, you can use the this cursor to perform queriescursor =conn.cursor ()#Execute QueryCursor.execute ("SELECT * FROM Department")#retrieve the records from the databaseRecords =Cursor.fetchall ()#records = Cursor.fetchone ()#print out the records using pretty printPprint.pprint (Records)

Postgre Database Python operations