I tried to find it in Google, but there is either some kind of software for storing information about watched movies, or setup guides. Maybe looking for the wrong, I do not know.

I use PostgreSQL. I need a database with already filled tables with movie descriptions, preferably with posters (not necessarily BLOBs inside the database, the main thing is that you can easily link information in the database with picches in a directory, for example).

Found only this file (in the archive archive, and in it file 24.sql): https://yadi.sk/d/pduURVBVqfvDK

But when I try to import via pgAdmin, I get an error:
enter image description here

I can't even read the error = /

When trying to enter a command in the console manually:

>pg_restore.exe --host "54.171.54.234" --port "5432" --username "postgres" --no-password --dbname "recommenderdb" --verbose "C:\\Users\\kamil\\Downloads\24.sql" pg_restore: [архиватор] входной файл не похож на архив
  • SQL should be sent to psql . - D-side
  • @ D-side Can I do a little more detail how to do this? - MrModest
  • Can. Look at the pg_dump documentation , one of the output formats of which is bare SQL. - D-side
  • one
    Judging by the background, it is for MySQL. - D-side
  • one
    Reverse - remove, where the column names do not conflict with the reserved SQL words and do not need to enclose them in any quotes. Are you familiar with syntax in postgesql? - Mike

0