Skip to content

Instantly share code, notes, and snippets.

@kevinkirkup

kevinkirkup/PostgreSQL_AutoIncrement.sql

Created November 26, 2013 04:58
Show Gist options
  • Save kevinkirkup/7653687 to your computer and use it in GitHub Desktop.
Save kevinkirkup/7653687 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL AutoIncrement
Raw
PostgreSQL_AutoIncrement.sql
CREATE SEQUENCE <field_seq>;
ALTER TABLE <table>
ALTER COLUMN <field> TYPE SMALLINT USING <field>::integer
, ALTER COLUMN <field> SET NOT NULL
, ALTER COLUMN <field> SET DEFAULT nextval('<field_seq>');
ALTER SEQUENCE <field_seq>
OWNED BY <table>.<field>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment