-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathload.sql
More file actions
14 lines (7 loc) · 1.03 KB
/
load.sql
File metadata and controls
14 lines (7 loc) · 1.03 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
COPY OFFSET 2 INTO name_basics FROM '/home/john/Projects/imdb/data/name.basics.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_akas FROM '/home/john/Projects/imdb/data/title.akas.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_basics FROM '/home/john/Projects/imdb/data/title.basics.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_crew FROM '/home/john/Projects/imdb/data/title.crew.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_episode FROM '/home/john/Projects/imdb/data/title.episode.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_principals FROM '/home/john/Projects/imdb/data/title.principals.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';
COPY OFFSET 2 INTO title_ratings FROM '/home/john/Projects/imdb/data/title.ratings.tsv' ON CLIENT USING DELIMITERS '\t', E'\n' NO ESCAPE NULL AS '\\N';