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.
When generating a new project the resulting powershell export script contains an if else more akin to bash. It should be:
if ($etype -eq "TABLE") {
$blob_to_lo=""
} else {
$blob_to_lo=""
}
When generating a new project the resulting powershell export script contains an if else more akin to bash. It should be: if ($etype -eq "TABLE") { $blob_to_lo="" } else { $blob_to_lo="" }