阅读背景:

将数据从csv文件导入到postgres表而不先创建表

来源:互联网 

I have tens of csv files with over a hundred columns in each. I need to upload these files to postgres tables so to process them and transfer the data to relational tables. I don't want to process each file manually to extract the column names as this might be a repetitive process. Neither the pgAdmin import tool nor the COPY function processes the first row to create columns of the table. So what would be the best approach to handle this issue?I have tens of csv files with over a hundred co




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

分享到: