Обсуждение: psql Copy question

Поиск

Список

Период

Сортировка

psql Copy question

От

"Virag Saksena"

Дата:

20 февраля 2006 г., 03:25:11

Hi,

I am using copy command in psql to load several million rows from a file

Is it possible to have a progress indicator print a dot after every 100,000 rows are inserted ?

Regards,

Virag

Re: psql Copy question

От

Richard Huxton

Дата:

20 февраля 2006 г., 10:05:55

Virag Saksena wrote:
> Hi,
>     I am using copy command in psql to load several million rows from a file
> Is it possible to have a progress indicator print a dot after every 100,000 rows are inserted ?

No - sorry.

--
   Richard Huxton
   Archonet Ltd

Re: psql Copy question

От

"A. Kretschmer"

Дата:

20 февраля 2006 г., 10:58:05

am  19.02.2006, um 23:24:57 -0800 mailte Virag Saksena folgendes:
> Hi,
>     I am using copy command in psql to load several million rows from a file
> Is it possible to have a progress indicator print a dot after every 100,000 rows are inserted ?

split the file into files with only 100,000 rows, copy every separately and
echo a message between the files?



Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: psql Copy question

psql Copy question

Re: psql Copy question

Re: psql Copy question