Re: A cronjob for copying a table from Oracle

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A cronjob for copying a table from Oracle
Date: 2010-12-10 11:33:53
Message-ID: idt36u$b20$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Farber, 10.12.2010 12:02:
> I'm preparing a PHP-script to be run as a nightly cronjob
> and will first find the latest qdatetime stored in my local
> PostgreSQL database and then just "select" in remote Oracle,
> "insert" into the local PostgreSQL database in a loop.
>
> But I wonder if there is maybe a cleverer way to do this?
>
> And I'm not sure how to copy the Oracle's strange DATE
> column best into PostgreSQL, without losing precision?

Oracle's DATE includes a time part as well.

So simply use a timestamp in PostgreSQL and everything should be fine.

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2010-12-10 11:53:09 Re: A cronjob for copying a table from Oracle
Previous Message Szymon Guz 2010-12-10 11:28:45 Re: Cannot Achieve Performance