Hi Baitang, Yes, you can, but only constant value at the moment. So literal value such as ‘string’, 0, 0.0 would work well, but CURRENT_TIME will not. (As far as I know.)
Best, -- Juvenn Woo Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Friday, 14 July 2017 at 3:29 PM, 曾柏棠 wrote: > hi all, > Can set default value for column in phoenix ? > for example : > > CREATE TABLE api.hahah( > subscribe_time bigint not null , > hahha varchar default 'aaa', > CONSTRAINT pk PRIMARY KEY (subscribe_time) > ) > > > Thanks ! >