imdb_to_postgres/imdb_data.sql at master · akamor/imdb_to_postgres · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
\copy public.name_basics from name.basics.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.ratings from title.ratings.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.principals from title.principals.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.episodes from title.episode.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.crews from title.crew.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.title_basics from title.basics.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');

\copy public.title_akas from title.akas.tsv with (format 'csv', delimiter E'\t', null '\N', header true, quote E'\b');