Remove autoincrement from postgresql field

Question

I have an existing table in a db, FK'd from several others, SQL below:

CREATE TABLE forecastsource (
    source_id integer DEFAULT nextval(('public.forecastsource_source_id_seq'::text)::regclass) NOT NULL,
    source_name character varying NOT NULL
);

I want to remove the autoincrement from the id field, and just move it to be a int field (without losing the current data in the table). How would I do that, other than dropping and recreating the table?

Answer 1

Just drop the default value:

ALTER TABLE forecastsource ALTER COLUMN source_id DROP DEFAULT;

You probably also want to drop the sequence then.