Re: Question about COPY command

Поиск
Список
Период
Сортировка
Искать
От
Andrej
Тема
Re: Question about COPY command
Дата
Msg-id
b35603930901081302ob670d9au3cbd1274d0bf322c@mail.gmail.com
Ответ на
Re: Question about COPY command (Josh Harrison)
Список
Дерево обсуждения
Question about COPY command "Josh Harrison" <joshques@gmail.com>
Re: Question about COPY command Ragnar Hafstað <gnari@simnet.is>
Re: Question about COPY command "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Question about COPY command "Josh Harrison" <joshques@gmail.com>
Re: Question about COPY command Andrej <andrej.groups@gmail.com>
Re: Question about COPY command Raymond O'Donnell <rod@iol.ie> 
2009/1/9 Josh Harrison :
> 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
В списке pgsql-general по дате отправления
Предыдущее
От: Andrus
Дата:
Следующее
От: Richard Huxton
Дата:
FAQ