ALTER TABLE files ADD COLUMN IF NOT EXISTS file_url TEXT; UPDATE files SET file_url = ''; ALTER TABLE files ALTER COLUMN file_url SET NOT NULL; COMMENT ON COLUMN files.file_url IS '完整路径';