Skip to content

Instantly share code, notes, and snippets.

@phunguyen19

phunguyen19/sql-add-type-if-not-exist.sql

Last active June 10, 2022 14:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save phunguyen19/5be7ad256d4d2962c0121311cc4cc671 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save phunguyen19/5be7ad256d4d2962c0121311cc4cc671 to your computer and use it in GitHub Desktop.
Download ZIP
sql add type if not exist
Raw
sql-add-type-if-not-exist.sql
DO $$ BEGIN
CREATE TYPE public.import_deliveries_delivery_state_enum AS ENUM
('10', '20');
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment