← All recipes
Moderne licensed

Convert Oracle data types to PostgreSQL

Recipe IDorg.openrewrite.sql.ConvertOracleDataTypesToPostgres
Artifactorg.openrewrite.recipe:rewrite-sql

Replaces Oracle-specific data types with PostgreSQL equivalents.

Composite recipepostgresqlsqloracleProprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe org.openrewrite.sql.ConvertOracleDataTypesToPostgres

If the recipe isn’t available locally, install it with:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1

Definition

This recipe runs the following recipes in order.

Data tables

Structured output this recipe can produce.

  • Source files that had resultsSource files that were modified by the recipe run.org.openrewrite.table.SourcesFileResults
  • Source files that had search resultsSearch results that were found during the recipe run.org.openrewrite.table.SearchResults
  • Source files that errored on a recipeThe details of all errors produced by a recipe run.org.openrewrite.table.SourcesFileErrors
  • Recipe performanceStatistics used in analyzing the performance of recipes.org.openrewrite.table.RecipeRunStats