質問編集履歴
2
内容の追記
title
CHANGED
File without changes
|
body
CHANGED
@@ -3,6 +3,16 @@
|
|
3
3
|
**解決したい問題**
|
4
4
|
下記エラーの対処方法をご教授いただきたいです。
|
5
5
|
|
6
|
+
**一応の解決方法**
|
7
|
+
下記で一応動きました。。
|
8
|
+
```sql
|
9
|
+
\encoding utf8
|
10
|
+
|
11
|
+
drop table access_log;
|
12
|
+
\i src/access_log.ct
|
13
|
+
\copy access_log from 'src/access_log.bz2.csv' with csv header null '' delimiter ',' quote e'"';
|
14
|
+
```
|
15
|
+
|
6
16
|
**エラー内容**
|
7
17
|
```log
|
8
18
|
|
@@ -77,4 +87,7 @@
|
|
77
87
|
|
78
88
|
**環境**
|
79
89
|
* Windows10
|
80
|
-
* PostgresSQL 9.4
|
90
|
+
* PostgresSQL 9.4
|
91
|
+
|
92
|
+
**参考サイト**
|
93
|
+
[PostgreSQLのcopyではまった](http://deta.hateblo.jp/entry/2015/09/10/094157)
|
1
文章の変更
title
CHANGED
File without changes
|
body
CHANGED
@@ -18,6 +18,18 @@
|
|
18
18
|
16632811:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:30 +0900~GET~/index.php?q=hoge_fuga&search_id=1234"~200~144241~-~-
|
19
19
|
16632832:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:32 +0900~GET~/index.php?q=hoge_fuga&search_id=1234&page=piyo~200~331344~-~-
|
20
20
|
|
21
|
+
$ tail -10 access_log.tsv
|
22
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=ghi&q%3Dabc%26id%3D123&text=&_=123~200~38~https://www.fuga.com/index.php?q=abc&id=1234~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
23
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=def~200~56~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
24
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&q=abc&id=123~200~306~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
25
|
+
1-2-3.hoge.fuga.ad.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?q=123&search=%AB%BC%DF~200~44979~https://www.google.com/~Mozilla/5.0 (Linux; Android 8.1.0; F-04K Build/V18R067C) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Mobile Safari/537.36
|
26
|
+
123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def&search=~200~51~https://www.hoge.net/index.php?q=123~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
27
|
+
123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def~200~56~https://www.hoge.net/~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
28
|
+
Oct 1 02:00:00 svr1 newsyslog[50902]: logfile turned over
|
29
|
+
hgoe.fuga.co.jp~-~-~01/Oct/2018:02:00:00 +0900~GET~/blog/?q=1~200~19843~-~-
|
30
|
+
hoge1234567890.fuga.net~-~-~01/Oct/2018:02:00:00 +0900~GET~/index.php?q=abc&page_id=1234&gclid=ABCDEFG~200~47956~-~Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) GSA/59.0.213668279 Mobile/14D27 Safari/602.1
|
31
|
+
.
|
32
|
+
|
21
33
|
```
|
22
34
|
|
23
35
|
**バッチファイル**
|