chedder123
Programmer
Ok... I feel really dumb now. I'm going to buy a book. I believe this is the command, however it's not working.
ALTER TABLE leads ALTER created SET timestamptz DEFAULT 'now' NOT NULL
ALTER TABLE leads ALTER export_counter SET int4 DEFAULT '0' NOT NULL
I already have a populated table and just wanted to change those two variables so it won't just be null everytime a new row is added. Can anyone check the syntax on that and tell me what I should be doing?
Thanks,
Chad
ALTER TABLE leads ALTER created SET timestamptz DEFAULT 'now' NOT NULL
ALTER TABLE leads ALTER export_counter SET int4 DEFAULT '0' NOT NULL
I already have a populated table and just wanted to change those two variables so it won't just be null everytime a new row is added. Can anyone check the syntax on that and tell me what I should be doing?
Thanks,
Chad