CREATE TABLE account (
  account_number int(11) primary key NOT NULL,
  balance float DEFAULT NULL
);

CREATE SEQUENCE account_account_number_seq;

ALTER TABLE account
    ALTER COLUMN account_number
        SET DEFAULT NEXTVAL('account_account_number_seq');