Differences

This shows you the differences between two versions of the page.

--- postgresqlimdb [2024/03/08 10:22] – z0hpvk
+++ postgresqlimdb [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 The import of the data was based on the script here: [[https://gist.github.com/IllusiveMilkman/2a7a6614193c74804db7650f6d3c2bd2 | Import IMDB Datasets into Postgres]]\\
-Run the below script as the postgres if possible user to avoid permission issues.\\
+Run the below script as the postgres user to avoid permission issues.\\
 <code BASH>
-printf "Removing old folders \n"
+printf "Removing and create folder \n"
 rm -rf imdb-datasets/
-printf "Creating new folders \n"
 mkdir imdb-datasets/
-printf "Downloading datasets from https://datasets.imdbws.com \n"
+printf "Download datasets from https://datasets.imdbws.com \n"
 cd imdb-datasets
 curl -O https://datasets.imdbws.com/name.basics.tsv.gz
@@ Line 72: / Line 70: @@
 ALTER TABLE name_basics ALTER knownfortitles TYPE text[] USING string_to_array(knownfortitles, ',');
 ALTER TABLE title_basics ALTER genres TYPE text[] USING string_to_array(genres, ',');
+ALTER TABLE title_crew ALTER directors TYPE text[] USING string_to_array(directors, ',');
+ALTER TABLE title_crew ALTER writers TYPE text[] USING string_to_array(writers, ',');
 </code>