質問編集履歴
1
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
|
|
12
12
|
for /r D:\batch\csv\1 %%f IN (*.recv) do (
|
|
13
13
|
|
|
14
|
-
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -c "copy %TABLENAME% from '%%
|
|
14
|
+
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -c "copy %TABLENAME% from '%%f' with csv header delimiter ','"
|
|
15
15
|
)
|
|
16
16
|
|
|
17
17
|
D:\batch\bin(psql -h localhost -p 5432 -U test_user -d test_db -c"copy tbl_test from 'D:\batch\csv\1\Data_20211214.recv' with csv header delimiter ','" )
|
|
@@ -36,7 +36,7 @@
|
|
|
36
36
|
set PGPASSFILE=D:\batch\bin\pgpass.conf
|
|
37
37
|
set %SQLFILE%='inport.sql'
|
|
38
38
|
for /r D:\batch\csv\1 %%f IN (*.recv) do (
|
|
39
|
-
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -f %SQLFILE% -v %TABLENAME%=%TABLENAME% -v %inputpath%=%
|
|
39
|
+
psql -h %HOST% -p %PORT% -U %USER% -d %DBNAME% -f %SQLFILE% -v %TABLENAME%=%TABLENAME% -v %inputpath%=%f
|
|
40
40
|
)
|
|
41
41
|
```
|
|
42
42
|
inport.sql
|