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... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
