The local psql command could not be located

sql windows postgresql heroku postgresql-9.2
TheMarron picture TheMarron · Mar 22, 2013 · Viewed 27.4k times · Source

I'm following the instructions found here. When I try to run $ heroku pg:psql or $ heroku pg:psql HEROKU POSTGRESQL_BROWN I recieve the following error message:

! The local psql command could not be located ! For help installing psql, see local-postgresql

I can't find anything useful on the link it gives me (it just links to the instructions I was already using, but further down the page) nor can I find this error anywhere else.

If I've missed anything you need to know to answer this, just let me know. I'm rather new to all this and teaching myself as I go.

Answer

Straff picture Straff · May 2, 2013

I had same error even after installing Postgres locally. But after seeing this I saw that "pqsl" was not in the PATH so I then did

PATH=%PATH%;C:\Program Files\PostgreSQL\9.2\bin

which worked for me

Related questions

How to create a database with UTF-8 collation in PostgreSQL on Windows?

I'm configuring PostgreSQL db for the Bitbucket Server on Windows. In the official guide it says that: The database must be configured to use the UTF-8 character set. It doesn't strictly say that you have to set collation to UTF-8, …

Read More
Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
Connecting to Microsoft SQL server using Python

I am trying to connect to SQL through python to run some queries on some SQL databases on Microsoft SQL server. From my research online and on this forum the most promising library seems to be pyodbc. So I have …

Read More