· 8 years ago · Jun 05, 2018, 10:22 AM
1DROP TABLE if exists aztemp;
2
3CREATE TABLE aztemp
4(
5 user_email text
6);
7
8DROP TABLE if exists aztemp1;
9
10CREATE TABLE aztemp1
11(
12 user_email text
13);
14
15
16COPY aztemp FROM '/var/tmp/bulk_loader_20120118100756.txt';
17COPY aztemp1 FROM '/var/tmp/bulk_loader_20120118100756.txt' with csv delimiter E':';
18
19select count(*) from aztemp; 1434468
20select count(*) from aztemp1; 1426781
21
22
23----The file bulk_loader_20120118100756.txt contains 1434468 lines. Why is it that when I use a delimiter ':' about 7k rows are not loaded.