CODEWITHSUNDEEP
postgresql
KIM
KIM

Reputation: 1254

how to migrate oracle data into postgres?

I have a oracle database holding about 2TB of data that I have to migrate to postgreSQL. I'm learning onCOPY command of pgsql and pgloader.

The problem is....

  1. copy command has delimeter option which Specifies the character that separates columns within each row (line) of the file. This must be a single one-byte character according to manual. What if I need secondary delimeter(like enclosed by option that oracle has)?

  2. There is no update since 2010-04 on [http://pgloader.projects.postgresql.org]... so I don't think it's recommended way...

Are there another options I'm missing?

Upvotes: 1

Views: 1394

Answers (2)

Dmitry Orlov
Dmitry Orlov

Reputation: 43

I think You should write some program in any lang or use http://www.enterprisedb.com/solutions/oracle-migration-assessment

Upvotes: 2

Chris Travers
Chris Travers

Reputation: 26454

A couple points. First you can use COPY with CSV formats so if you are worried about handling of commas for example, you can just copy as CSV and let the quoting rules handle that. CSV is widely supported as a data export format anyway and so that's probably the best way to handle that case.

Secondly your delimiter can be escaped by a backslash if you need it.

Upvotes: 1

Related Questions