How can I copy a .sql file to a Postgresql?

Question

I have installed confluence and postgres on synology nas using docker. Both run succesfully. Now I have to copy the data from a .sql file to the database that I have created in postgres.

How can I do this? I tried looking up different things but nothing helps.

regards

question from:https://stackoverflow.com/questions/65920117/how-can-i-copy-a-sql-file-to-a-postgresql

Answer 1

Use could use psql and let read commands from the file and execute this in your database. --file=? will do the trick.