Idea: Adding progress markers to the import

[smil2k]

During importing large datasets it would be good to see where is the import heading.

Ora2pg could emit \echo commands before each COPY/INSERT. Emitting progress. Eg.:

Importing TBL_WHATEVER [10001/10040402] COPY 10000 Importing TBL_WHATEVER [20000/10040402] COPY 10000

[darold]

I do not understand, you have the progress bar that gives this information, no?

[smil2k]

In case of OUTPUT, then the progress marker is shown while exporting.

But in case of importing all I see is "COPY 10000"

No way of knowing whether i can go for a tea ;-)

[darold]

I guess that you have first exported the data to file and importing them using psql. If you use direct import you will benefit from the progress bar :-)

[smil2k]

Sure:-) I'm using these exports as reference also. Others could install it for their machines.

Anyhow just an idea.

[smil2k]

Would you accept pull request for this?

[darold]

yes