From: Carlos Sousa <carlosdsousa@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: small proble
Date: Mon, 11 Nov 2002 14:30:48 +0000
Message-ID: <F190eSnJgz24z7apNYV0000509a@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
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 proble
In-Reply-To: <F190eSnJgz24z7apNYV0000509a@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