<PYTHON>PostgreSql 접속

import psycopg2
 
conn_string = "dbname = 'testDB' user='flower' host = 'localhost' password = 'qwe123'"
try:
    conn = psycopg2.connect(conn_string)
except:
    print "error database connection"
cur = conn.cursor()
 
sql_string = "SELECT datname FROM pg_database"
cur.execute(sql_string)
result = cur.fetchall()
print "\nShow me the databases:\n"
for row in rows:
    print "   ", row[0]
conn.commit()