Open up a sql file and running it in PostgreSQL is having an issue with the path because of space in the folder name

Question

I'm using command line to run the following script:

C:\Progra~1\pgAdmin III\1.16\psql -d [tablename] -h [servername] -p 5432 -U postgres -f C:\test\query.sql

But the issue comes with the folder pgAdmin III that I want to run the query in since it has a space in the name. When I changed the actual folder name to pgAdminIII and updated the script it will run the script just fine. I was wondering how I can run this script without physically modifying the folder name (i.e. keep it as pgAdmin III)?

Ansgar Wiechers · Accepted Answer · 2013-04-10 18:19:50Z

2

Put double qoutes around a path with spaces in it:

"C:\Progra~1\pgAdmin III\1.16\psql" -d [tablename] ...

answered Apr 10, 2013 at 18:19

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Open up a sql file and running it in PostgreSQL is having an issue with the path because of space in the folder name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related