Postgres Code Snippet

empty

codesnap

19 views

#查看字段长度（varchar）

    SELECT information_schema.columns."column_name",character_maximum_length
FROM information_schema.columns
WHERE table_name = '表名'

    ALTER TABLE 表名
ALTER COLUMN 列名 TYPE VARCHAR(5000);