SEO

#1 (**permalink**) 04-09-2008, 08:27 AM

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

#2 (**permalink**) 04-09-2008, 08:28 AM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-09-2008, 08:28 AM

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 ===

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

psql Copy question