Re: Migrating db from Oracle to Postgresql

Поиск
Список
Период
Сортировка
От Colin Barnard
Тема Re: Migrating db from Oracle to Postgresql
Дата
Msg-id 3BFA3D46.C3DED89@dcs.qmul.ac.uk
обсуждение исходный текст
Ответ на Re: Migrating db from Oracle to Postgresql  (Francisco Reyes <lists@natserv.com>)
Список pgsql-novice
Francisco Reyes wrote:
>
>
> Can't you get the data to an ASCII file?
> It doesn't have to be with "inserts". A plain ASCII file with some sort of
> separator between column will do. You then can use the copy command to
> import your data.

Thanks Francisco,

    Transferring the table data is not a problem, I was hoping to be able
to transfer all the other stuff as well, constraints, sequences etc in
one hit. If that's not possible I'll have to do it piecemeal.

Thanks again
Regards
Colin

--

Colin Barnard  cgb@dcs.qmul.ac.uk

Department of Computer Science, Queen Mary,
University of London, Mile End Road, London E1 4NS.
Tel: +44 (0)20 7882 5234  Fax: +44 (0)20 8980 6533

And now for something completely off the wall ...

|\
|-0
|/
|
|   /
|_/

(Its a hook for hanging a picture on)

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Triggers & Compiled C Language Functions
Следующее
От: Danni Coy
Дата:
Сообщение: Emergency backup question.