質問編集履歴
1
誤字
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -24,7 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
|
|
27
|
-
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -c "copy %TABLENAME% from '%%
|
|
27
|
+
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -c "copy %TABLENAME% from '%%f' with csv header delimiter ','"
|
|
28
28
|
|
|
29
29
|
)
|
|
30
30
|
|
|
@@ -74,7 +74,7 @@
|
|
|
74
74
|
|
|
75
75
|
for /r D:\batch\csv\1 %%f IN (*.recv) do (
|
|
76
76
|
|
|
77
|
-
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -f %SQLFILE% -v %TABLENAME%=%TABLENAME% -v %inputpath%=%
|
|
77
|
+
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -f %SQLFILE% -v %TABLENAME%=%TABLENAME% -v %inputpath%=%f
|
|
78
78
|
|
|
79
79
|
)
|
|
80
80
|
|