通过Python修改Postgresql的表格:添加Column

发布网友发布时间：2022-04-10 21:41

共2个回答

懂视网时间：2022-04-11 02:03

!/usr/bin/python import psycopg2 from datetime import datetime db_host = "xxxxxx-esb-xx.xxxxx.xx-xxxx.rds.xxxxx.com" db_port = 5432 db_name = "xxx" db_user = "xxx" db_pass = "xxxx" db_table = "xxxxx" biller_code = "111111" biller_short_name = "test_short" biller_long_name = "test_long" def make_conn(): conn = None try: conn = psycopg2.connect("dbname=‘%s‘ user=‘%s‘ host=‘%s‘ password=‘%s‘" % (db_name, db_user, db_host, db_pass)) print "connected to postgres db successfully" except: print "I am unable to connect to the database" return conn try: connection = make_conn() cursor = connection.cursor() cursor.execute("SELECT * FROM billers where biller_code = ‘%s‘;" % biller_code) numOfRows = cursor.rowcount print("%s rows found for the biller code: %s" % (numOfRows, biller_code)) if(numOfRows<=0): dt = datetime.now() cursor.execute("insert into billers (biller_code, biller_short_name, biller_long_name, active, min_length, max_length, reg_exp, check_digit_algo, created_at, updated_at) values (%s, %s, %s, true, 0, 100, ‘NONE‘, ‘NONE‘, %s, %s)", (biller_code, biller_short_name, biller_long_name, dt, dt)) connection.commit() print("inserted %s rows successfully" % cursor.rowcount) except (Exception, psycopg2.Error) as error : print ("Error caught", error) finally: #closing database connection. if(connection): cursor.close() connection.close() print("PostgreSQL connection is closed")

python操作postgreSQL数据库

标签：cut into except return print solution tail close end

热心网友时间：2022-04-10 23:11

alter table 表名 alter column 字段名 varchar(50) not null;
或者
alter table 表名 modify column 字段名 varchar(50) not null;
字段类型自定义，可以是varchar、int等类型，根据不同的数据库版本，修改指令可能是alter column或modify column
还不错，希望你采纳。追问恩解决了，我用python的try做的。多谢您。