map Oracle NUMBER columns to correct Pg type

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

diff --git a/dump_oracle_table_for_pg b/dump_oracle_table_for_pg
index 116c005..93a2312 100755 (executable)
--- a/dump_oracle_table_for_pg
+++ b/dump_oracle_table_for_pg
@@ -150,7 +150,7 @@ sub get_pg_column_type {
         if ($column_def->{DATA_SCALE} == 0) {
             $type = 'INTEGER';
         } else {
-            $type = "NUMBER($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
+            $type = "NUMERIC($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
         }
     }
     if (defined $type) {