How to run heroku pg:psql query in command line?

Asked Nov 01 '22 at 09:15

Active Nov 01 '22 at 12:41

Viewed 135 times

After

heroku login

I'm trying to run in cmd:

echo "select * from public.table limit 2;" | heroku pg:psql -app "my-app::DATABASE_URL"

and get error: "The local psql command could not be located"

The local postgres installed in : C:\Program Files\PostgreSQL\14\bin when I try to set path

set PATH=%PATH%;C:\Program Files\PostgreSQL\14\bin

setx PATH "PATH%;C:\Program Files\PostgreSQL\14\bin"

I get error like this:

C:\Program : The term 'C:\Program' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:17
+ set PATH=%PATH%;C:\Program Files\PostgreSQL\14\bin
+                 ~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (C:\Program:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

How I can to run this ?

edited Nov 01 '22 at 12:04

asked Nov 01 '22 at 09:15

Galat

You need to add that directory to your `PATH`. Please see the marked duplicates. – ChrisGPT was on strike Nov 01 '22 at 11:11
but can't to set this directory to path – Galat Nov 01 '22 at 12:07
Please see the two new duplicates that are specific to PowerShell – ChrisGPT was on strike Nov 01 '22 at 12:41

How to run heroku pg:psql query in command line?

0 Answers0