| From: | Andrej <andrej(dot)groups(at)gmail(dot)com> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com>, "postgresql Forums" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question about COPY command |
| Date: | 2009-01-08 21:02:08 |
| Message-ID: | b35603930901081302ob670d9au3cbd1274d0bf322c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/1/9 Josh Harrison <joshques(at)gmail(dot)com>:
> My question is is it possible to read the oracle data from the oracle
> database and copy them into postgresql database directly by using COPY
> command instead of jdbc preparedstatement(INSERT command) ?
Should be possible; just got to make sure that you have all the formatting
right, you may need something like sed or awk to make them match ...
Of course it also depends on the complexity of "database"; if you
have several tables w/ referential integrity then copy obviously wouldn't
be the right tool for the job.
> Thanks
> Josh
Cheers,
Andrej
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-01-08 21:39:40 | Improving compressibility of WAL files |
| Previous Message | Andrus | 2009-01-08 20:44:08 | Re: column "id" is of type integer but expression is of type character |