Remove autoincrement from postgresql field Remove autoincrement from postgresql field postgresql postgresql

Remove autoincrement from postgresql field


Just drop the default value:

ALTER TABLE forecastsource ALTER COLUMN source_id DROP DEFAULT;

You probably also want to drop the sequence then.