阅读背景:

如何使Postgres Copy忽略大型txt文件的第一行

来源:互联网 

I have a fairly large .txt file ~9gb and I will like to load this txt file into postgres. The first row is the header, followed by all the data. If I postgres COPY the data directly, the header will cause an error that data type do not match with my postgres table, so I will need to remove it somehow.I have a fairly large .txt file ~9gb and I will




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: