fix_column.py 353 B

1234567891011121314
  1. import psycopg2
  2. conn = psycopg2.connect(
  3. host='47.109.147.74',
  4. port=5432,
  5. user='maas_collect',
  6. password='jLDMdRjYZyWLJSfr',
  7. database='maas_collect'
  8. )
  9. cur = conn.cursor()
  10. cur.execute("ALTER TABLE \"user\" ALTER COLUMN password_hash TYPE VARCHAR(512);")
  11. conn.commit()
  12. print('已修改 password_hash 字段长度为 512')
  13. conn.close()