treble37 · February 8, 2019 22:26
diff --git a/rename_column.sql b/rename_column.sql
 DO $$
 BEGIN
  IF NOT EXISTS(SELECT *
    FROM information_schema.columns
    WHERE table_name='my_table' and column_name='my_column')
  THEN
      ALTER TABLE "public"."my_table" RENAME COLUMN "my_column" TO "my_new_column";
  END IF;
 END $$;
	DO $$
	BEGIN
	IF NOT EXISTS(SELECT *
	FROM information_schema.columns
	WHERE table_name='my_table' and column_name='my_column')
	THEN
	ALTER TABLE "public"."my_table" RENAME COLUMN "my_column" TO "my_new_column";
	END IF;
	END $$;