search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

There is no control for default values #1697

Closed tbw777 closed 5 months ago

tbw777 commented 9 months ago

Can't change current_timestamp to now() and there is no control for default values (TYPE SECTION is useful, but not support this).

darold commented 8 months ago

Why do you want to replace current_timestamp by now()? This is the same. But if you want to do so this is pretty easy using a system command:

grep -ril current_timestamp schema/ | xargs -i perl -p -i -e 's/current_timestamp/now()/ig' {}

Can you also elaborate more about "control for default values"? What are you thinking about exactly?

tbw777 commented 8 months ago

because now() is shortest form and used by liquibase

What are you thinking about exactly? I mean that can't change current_timestamp to now() in config