summaryrefslogtreecommitdiff
path: root/contrib/oracle/Ora2Pg.pm
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-05-03 04:11:08 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-05-03 04:11:08 +0000
commit8338cc03a8915e28024981d09193612ec4a83819 (patch)
tree8845f3a7695af8370cb60c2461d39e70be667584 /contrib/oracle/Ora2Pg.pm
parent53cedcac22bca29bb6ac766b04d5dd08db77ac03 (diff)
downloadpostgresql-8338cc03a8915e28024981d09193612ec4a83819.tar.gz
Remove the last traces of datatypes datetime and timespan.
Diffstat (limited to 'contrib/oracle/Ora2Pg.pm')
-rw-r--r--contrib/oracle/Ora2Pg.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/oracle/Ora2Pg.pm b/contrib/oracle/Ora2Pg.pm
index fa42430c32..e2dabfc75b 100644
--- a/contrib/oracle/Ora2Pg.pm
+++ b/contrib/oracle/Ora2Pg.pm
@@ -1290,8 +1290,8 @@ sub _sql_type
'VARCHAR2' => 'varchar',
'NVARCHAR2' => 'varchar',
# The DATE data type is used to store the date and time information.
- # Pg type datetime should match all needs
- 'DATE' => 'datetime',
+ # Pg type timestamp should match all needs
+ 'DATE' => 'timestamp',
# Type LONG is like VARCHAR2 but with up to 2Gb.
# PG type text should match all needs or if you want you could use blob
'LONG' => 'text', # Character data of variable length