My requirement is pre-process the text file separated by comma(,) and bulkload into PostgreSQL table.
I think if our file is separated by some separator then it is easy to COPY into PostgreSQL table. That's the reason why I decided to pre-process the file before load.
I have 573 columns in my table. Is there any easiest way prepare the file with separator to load into the table?
or kindly suggest better way to proceed?
Thanks a lot in advance.