Re: Why is pg_dump using INSERTs instead of COPYs?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Why is pg_dump using INSERTs instead of COPYs?
Дата
Msg-id 200403311435.15942.peter_e@gmx.net
обсуждение исходный текст
Ответ на Why is pg_dump using INSERTs instead of COPYs?  (reina_ga@hotmail.com (Tony Reina))
Список pgsql-hackers
Дерево обсуждения 
Am Mittwoch, 31. März 2004 13:14 schrieb Tony Reina:
> I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
> past, pg_dump would dump database backups using COPY to restore the
> data. This time it appears that it has individual INSERTs for each
> tuple. Perhaps I'm missing this in the latest documentation, but I
> thought COPY was the default unless the --inserts switch is declared.

This is still the case.

> Can anyone think of why I'd be getting INSERTs?

Shell aliases perhaps.

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

Предыдущее
От: reina_ga@hotmail.com (Tony Reina)
Дата:
Сообщение: Why is pg_dump using INSERTs instead of COPYs?
Следующее
От: "Tony and Bryn Reina"
Дата:
Сообщение: Re: Why is pg_dump using INSERTs instead of COPYs?