Multiple COPYs

Поиск
Список
Период
Сортировка
От rasdj@frontiernet.net
Тема Multiple COPYs
Дата
Msg-id 1118939523.242964.265050@z14g2000cwz.googlegroups.com
обсуждение исходный текст
Ответы Re: Multiple COPYs
Re: Multiple COPYs
Список pgsql-general
Hello,

Having a great time with PG - ported an erp from oracle and db2. First
I tried MySql but choked somewhere in the 900 table region. I have a
python script to translate the syntax and it loads about 2000 tables.

Now I want to COPY my dumps - I have 1 data dump for each table. Any
tips on what to use so that I can read the file name into a variable
and pass it as the file name in the COPY command and have one script
load all my tables?

Thanks for any help.

Rasta DJ


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

Предыдущее
От: "eblues"
Дата:
Сообщение: Help: chinese character set support (EUC_TW to/from BIG5 conversion)
Следующее
От: stig erikson
Дата:
Сообщение: psql: FATAL: database "template1" is not currently accepting connections