python psycopg2使用_使用psycopg2动态更改python中的数据库(postgresql)

您只需再次使用database=dbname参数进行连接即可。请注意使用SELECT current_database()来显示我们工作的数据库，并使用SELECT * FROM pg_database显示可用的数据库：

from psycopg2 import connect

from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT

def show_query(title, qry):

print('%s' % (title))

cur.execute(qry)

for row in cur.fetchall():

print(row)

print('')

dbname = 'db_name'

print('connecting to default database ...')

con = connect(user ='postgres', host = 'localhost', password = '*****', port=5492)

con.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)

cur = con.cursor()

show_query('current database', 'SELECT current_database()')

cur.execute('CREATE DATABASE ' + dbname)

show_query('available databases', 'SELECT * FROM pg_database')

cur.close()

con.close()

print('connecting to %s ...' % (dbname))

con = connect(user ='postgres', database=dbname, host = 'localhost', password = '*****', port=5492)

cur = con.cursor()

show_query('current database', 'SELECT current_database()')

cur.close()

con.close()