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
1.03k stars 343 forks source link

How to change tab separated data using ora2pg to comma separated or something else #1536

Closed balajithriller closed 1 year ago

balajithriller commented 2 years ago

Currently in ora2pg data is extracted with tab separated and if i have values in the desc column of a table emp with a tab then there will be error, instead i want to uniquely separate the columns like ||*| or something like that.

darold commented 2 years ago

Yes, Ora2Pg use the COPY output format with a tabulation as separator but all tab characters in your data will be escaped into \t so no error should be reported.

What issue are you facing exactly?