On 2010-08-25, wstrzalka wrote:
> I'm currently playing with very large data import using COPY from
file.
>
> As this can be extremely long operation (hours in my case) the nice
> feature would be some option to show operation progress - how many
> rows were already imported.
>
> Or maybe there is some way to do it? As long as postgres have no read-
> uncommited I think I can estimate it only by destination table size ??
>
> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Hi,
You can use tools like pv for a progress bar and pipe the output into
psql.
HTH
--
Robert...