Re: A cronjob for copying a table from Oracle - Mailing list 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