From: Carlos Sousa <carlosdsousa@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: small problem
Date: Mon, 11 Nov 2002 14:30:48 +0000
Message-ID: <F214ek2ig4yorAxCT9E00005b5c@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: carlosdsousa@hotmail.com
Subject: Re: small problem
In-Reply-To: <F214ek2ig4yorAxCT9E00005b5c@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox