postgresql - How to import ZIpped file into Postgres Table -


i important file postgresql system(specificly redshift). have found arguement copy allows importing gzip file. provider data trying include in system produces data in .zip. built in postgres commands opening .zip?

can like

unzip -c myfile.zip | gzip myfile.gz

easy enough automate if have enough files.


Comments