from pyPgSQL import PgSQL #host:port:database:user:password:options:tty src_db_conn_str = "ip:5432:dbname:username:password" dst_db_conn_str = "ip:5432:dbname:username:password" src_db = PgSQL.connect(src_db_conn_str) dst_db = PgSQL.connect(dst_db_conn_str) src_cursor = src_db.cursor() dst_cursor = dst_db.cursor() src_cursor.execute("select tablename from pg_tables where schemaname = 'public'"); tbl_name_list = src_cursor.fetchall() for tbl_name in tbl_name_list: dst_cursor.execute("drop table " + tbl_name[0]); dst_cursor.execute("create table " + tbl_name[0] + " ()"); src_cursor.execute("select * from table_coldef where tbl_name = '" + tbl_name[0] + "'"); tbl_def = src_cursor.fetchall() print "tbl_def = ", tbl_def for col_def in tbl_def: dst_cursor.execute("alter table " + col_def[0] + " add column " + col_def[1] + " " + col_def[2]); print "col_def = ", col_def src_db.commit() dst_db.commit() src_cursor.close(); src_db.close() dst_cursor.close(); dst_db.close() -------------------- (1)多回答问题。 (2)多提出问题。
python创建数据库并对表结构备份_python代码:将远程postgresql数据库表结构备份到别的主机...
最新推荐文章于 2023-02-08 12:34:18 发布