Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AC57747630E
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:30:51 -0500 (EST)
Received: from hotmail.com (f214.pav1.hotmail.com [64.4.31.214])
	by postgresql.org (Postfix) with ESMTP id 025C84762E2
	for <pgsql-sql@postgresql.org>; Mon, 11 Nov 2002 09:30:45 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Mon, 11 Nov 2002 06:30:48 -0800
Received: from 193.136.224.3 by pv1fd.pav1.hotmail.msn.com with HTTP;
	Mon, 11 Nov 2002 14:30:48 GMT
X-Originating-IP: [193.136.224.3]
From: "Carlos Sousa" <carlosdsousa@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: small problem
Date: Mon, 11 Nov 2002 14:30:48 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F214ek2ig4yorAxCT9E00005b5c@hotmail.com>
X-OriginalArrivalTime: 11 Nov 2002 14:30:48.0662 (UTC)
	FILETIME=[EDBB1F60:01C2898E]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/160
X-Sequence-Number: 10302

hi to all

I am doing a webpage and i manipulate data from a postgres database.
I need to do the same thing with a oracle database.
I am using pg_dump to transfer the database data from postgres to oracle
but there are a few problems with same data types in a table when i try to 
import it to a oracle database.

create table (...)
(...)
duration   interval default 7
hourDay    timestamp with time zome
(...)


if i replace this two data types with varchar2(50) it works but i would like 
if there's a better choice

thanks for your time and replay




_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail