From b7717b892d1f4c690baf55d680688b44492780f7 Mon Sep 17 00:00:00 2001
From: Galen Charlton <gmc@esilibrary.com>
Date: Wed, 6 Mar 2013 13:38:01 -0500
Subject: [PATCH] map Oracle NUMBER columns to correct Pg type

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
---
 dump_oracle_table_for_pg |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/dump_oracle_table_for_pg b/dump_oracle_table_for_pg
index 116c005..93a2312 100755
--- 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) {
-- 
1.7.2.5