CSV files not visible for script

[michalstolorz]

Hello, I have used files and scripts to setup AdventureWorks for postgres localy but when i run psql -U postgres -d Adventureworks < D:/pgadmin/AdventureWorks-for-Postgres-master/install.sql it created database schema but every time whlie copying data there was an error "./Department.csv: No such file or directory" or "Product.csv: No such file or directory". Please help.

[DomanovSN]

Hello, I have used files and scripts to setup AdventureWorks for postgres localy but when i run psql -U postgres -d Adventureworks < D:/pgadmin/AdventureWorks-for-Postgres-master/install.sql it created database schema but every time whlie copying data there was an error "./Department.csv: No such file or directory" or "Product.csv: No such file or directory". Please help.

Hello, had the same issue. I think you need to run psql -U postgres -d Adventureworks install.sql from your D:/pgadmin/AdventureWorks-for-Postgres-master folder. The script searches for .csv files in the current folder (e.g. ./Department.csv). Cheers!