Database migration from Oracle 12c to PostgreSQL

Please find below details of requirement:
1. We need help to migrate oracle data into PostgreSQL database.
2. Preferred approach is that export data from Oracle database using oracle commands so that we can run batch/ script and export data in one go.
3. Currently I am using spool feature to export data from oracle and it is working fine for some tables but in some tables I am facing challenges while import that data in PostgreSQL database.
For example I am exporting employee master data which is having address column and it has comma separated data so the data is split into different rows and giving error while import that data into PostgreSQL.

Please find below script which is I am using to export oracle data.:
set pagesize 0 embedded on
set colsep ,
set trimspool on
set heading on
set term off
set feed off
set feedback off
set echo off
set verify off
set underline off
set linesize 1500

spool D:/CIS2/city.csv
select city.citycode as id ,'"' || city.cityname || '"' as cityname,0 as stateid, case when city.isretired ='N' then 'true' else 'false' end as active ,sysdate as createdat,sysdate updatedat from city order by cityname;

spool off

4. Also please find below scenario that we have in database:
• PostgreSQL database having different table names , column names and also having some columns with different datatypes as compare to oracle database.
• For example -
Oracle
Column Name Datatype Data
isretired char Y/N

PostgreSQL
Column Name Datatype Data
active boolean true/false