• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addDefaultValueSequenceNext.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.postgresql.addDefaultValueSequenceNext.sql Maven / Gradle / Ivy

CREATE SEQUENCE  IF NOT EXISTS public.test_sequence START WITH 1 INCREMENT BY 1 MINVALUE 1
ALTER TABLE public.authors ADD sequence_referenced_column numeric
ALTER TABLE public.authors ALTER COLUMN  sequence_referenced_column SET DEFAULT nextval('public.test_sequence')
ALTER SEQUENCE public.test_sequence OWNED BY public.authors.sequence_referenced_column