pg_bulkload icon indicating copy to clipboard operation
pg_bulkload copied to clipboard

load part of the column from csv file to a table

Open Mad-Apes opened this issue 7 years ago • 1 comments

Hello, This version allow users load part of the column from csv file to a postgres table. I add two parameter. One is CSV_FIELDS means columns in a csv file. The other parameter is FINAL_FIELDS, this means colomns in a postgres table. for example: CSV_FIELDS=table_name,params_name,description,params_value,default_value,range_operator

FINAL_FIELDS=table_name,params_name,PP,MM

If the column in FINAL_FIELDS does not in CSV_FIELDS, then load this column to table. for example, PP does not in CSV_FIELDS, then PP will load to table.

I provide a file bulkload_cfg_report.ctl. You can look over it.

Mad-Apes avatar Jun 10 '18 15:06 Mad-Apes

Dear Mad-Apes. Thank you for sent PR. I was not able to check PR properly due to other work. I'll check the PR contents sent from the coming May. I apologize for the inconvenience and slow checked.

Best regards.

MoonInsung avatar Apr 21 '20 05:04 MoonInsung