我在postgresql 9.4数据库中定义了一个数组字段:
character varying(64)[]
我可以用一个空数组,例如{}作为该字段的默认值吗?
如果只设置括号{},我会遇到以下错误:
SQL error:
ERROR: syntax error at or near "{"
LINE 1: ...public"."accounts" ALTER COLUMN "pwd_history" SET DEFAULT {}
^
In statement:
ALTER TABLE "public"."accounts" ALTER COLUMN "pwd_history" SET DEFAULT {}