Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql Copy question

psql Copy question

From
"Virag Saksena"
Date:
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

From
Richard Huxton
Date:
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

From
"A. Kretschmer"
Date:
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    ===