If you want to use a sequence to automatically popluate the column at each insert, you can alter the column to support this with the below syntax:
ALTER TABLE myschema.mytable
ALTER COLUMN id SET DEFAULT nextval('myschema.mysequence'::regclass);
No comments:
Post a Comment