Re: Fastest way to import only ONE column into a table? (COPY doesn't work)

Поиск
Список
Период
Сортировка
От Rodrigo De León
Тема Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
Дата
Msg-id 1187241689.310082.153210@g4g2000hsf.googlegroups.com
обсуждение исходный текст
Ответ на Fastest way to import only ONE column into a table? (COPY doesn't work)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Ответы Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
Список pgsql-general
Дерево обсуждения 
On Aug 15, 11:46 pm, phoenix.ki...@gmail.com ("Phoenix Kiula") wrote:
> Appreciate any tips, because it would
> be nasty to have to do this with millions of UPDATE statements!

- Create an interim table
- COPY the data into it
- Do an UPDATE ... FROM ...

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

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Fastest way to import only ONE column into a table? (COPY doesn't work)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Deadlocks caused by a foreign key constraint