-
Notifications
You must be signed in to change notification settings - Fork 2
/
import_csv_postgresql.txt
executable file
·86 lines (78 loc) · 6.66 KB
/
import_csv_postgresql.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
\COPY actor FROM './src/actor.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY casting FROM './src/casting.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY dept FROM './src/dept.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY eteam FROM './src/eteam.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY game FROM './src/game.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ge FROM './src/ge.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY goal FROM './src/goal.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY movie FROM './src/movie.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY nobel FROM './src/nobel.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY nss FROM './src/nss.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY route FROM './src/route.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY stops FROM './src/stops.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY teacher FROM './src/teacher.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY world FROM './src/world.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY covid FROM './src/covid.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_CAT" FROM './src/INS_CAT.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_PRS" FROM './src/INS_PRS.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_MOD" FROM './src/INS_MOD.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_SPR" FROM './src/INS_SPR.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "CAM_SMO" FROM './src/CAM_SMO.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_RES" FROM './src/INS_RES.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "INS_QUE" FROM './src/INS_QUE.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Shift_type" FROM './src/Shift_type.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Level" FROM './src/Level.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Caller" FROM './src/Caller.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Customer" FROM './src/Customer.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Staff" FROM './src/Staff.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Shift" FROM './src/Shift.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Issue" FROM './src/Issue.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY room_type FROM './src/room_type.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY room FROM './src/room.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY rate FROM './src/rate.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY extra FROM './src/extra.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY guest FROM './src/guest.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY booking FROM './src/booking.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "CustomerAW" FROM './src/CustomerAW.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "CustomerAddress" FROM './src/CustomerAddress.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Address" FROM './src/Address.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "SalesOrderHeader" FROM './src/SalesOrderHeader.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "ProductCategory" FROM './src/ProductCategory.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "Product" FROM './src/Product.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "SalesOrderDetail" FROM './src/SalesOrderDetail.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "ProductModel" FROM './src/ProductModel.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "ProductDescription" FROM './src/ProductDescription.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY "ProductModelProductDescription" FROM './src/ProductModelProductDescription.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_staff FROM './src/ut_staff.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_student FROM './src/ut_student.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_room FROM './src/ut_room.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_modle FROM './src/ut_modle.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_event FROM './src/ut_event.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_attends FROM './src/ut_attends.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_teaches FROM './src/ut_teaches.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_occurs FROM './src/ut_occurs.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY ut_week FROM './src/ut_week.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY band FROM './src/band.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY composer FROM './src/composer.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY composition FROM './src/composition.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY concert FROM './src/concert.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY has_composed FROM './src/has_composed.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY musician FROM './src/musician.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY performance FROM './src/performance.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY performer FROM './src/performer.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY place FROM './src/place.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY plays_in FROM './src/plays_in.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY material FROM './src/material.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY dress_order FROM './src/dress_order.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY quantities FROM './src/quantities.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY garment FROM './src/garment.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY jmcust FROM './src/jmcust.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY dressmaker FROM './src/dressmaker.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY construction FROM './src/construction.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY order_line FROM './src/order_line.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY camera FROM './src/camera.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY keeper FROM './src/keeper.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY image FROM './src/image.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY permit FROM './src/permit.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY vehicle FROM './src/vehicle.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;
\COPY hadcet FROM './src/hadcet.csv' WITH DELIMITER ',' CSV NULL AS 'NULL' HEADER;