Postgres Code Snippet
empty
codesnap
17 views
May 22, 2024

#查看字段长度(varchar)

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

  

#更新字段类型或长度

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

  
Total PV : 0|UV : 0
Current Online:1
From :