How to import database in postgresql?

Question

PostgreSQL

Good evening! I am a total database newbie and decided to learn PostgreSQL. Started with a book from their website. It contains a link to the tutorial.

I put it on Windows XP under psql 9.6, no problems. But on Windows 7 with psql 10 nothing comes out. The command \i demo_small.sql
loads the database, everything seems to be in order, but if you switch to another database and return to the loaded one, it turns out that there is absolutely nothing in it, "no relations found" when you try to look at the list of tables. The same with the
team .
psql demo < demo_small.sql -U postgres
Perhaps the answer is on the surface and I'm just inattentive, but I've been struggling with this all day.

Answer 1

indicate the full paths, both to the postgre and to the imported
one, or fiddle with adding to PATH xs which, it seems, Postgres also has its own PATH

Answer 2

https://stackoverflow.com/questions/6842393/import...