From 2cf4260ba69542c64ac396a9b451d9d2bccae4cb Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 8 Jan 2019 22:30:24 -0600 Subject: [PATCH] Quote uploaded column headings to allow for mixed case, etc. --- src/pgwui_upload/views/upload.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/pgwui_upload/views/upload.py b/src/pgwui_upload/views/upload.py index 27ac93b..e41d557 100644 --- a/src/pgwui_upload/views/upload.py +++ b/src/pgwui_upload/views/upload.py @@ -240,7 +240,7 @@ class TableUploadHandler(TabularFileUploadHandler): bad_cols.append(col_name) else: # Add column to sql statement - insert_stmt += col_sep + col_name + insert_stmt += col_sep + doublequote(col_name) value_string += col_sep + '%s' col_sep = ', ' -- 2.34.1