问题描述
我正在尝试将PostgreSQL添加到我的$ PATH变量中.我尝试过此操作以查看psql的位置
I am trying to add PostgreSQL to my $PATH variable. I tried this to see where psql is
whereis psql
对此我没有回应.我确实安装了PostgreSQL.app，所以我从GUI中单击打开psql"，它提示终端打开并显示:
To which I got a null response. I do have the PostgreSQL.app installed so I clicked on "Open psql" from the GUI and it prompted the Terminal to open and display:
/Applications/Postgres.app/Contents/MacOS/bin/psql; exit;
所以我试图将以上内容添加到我的~/.bash_profile中的$PATH变量中(这可能有其自身的问题，因为我不知道是否可以将带有.app扩展名的路径添加到$ PATH中)，但是何时我重新启动终端，然后执行echo $PATH | grep Postgres.app我什么都没做.
So I tried to add the above to the $PATH variable in my ~/.bash_profile (which may have its own problems since I don't know if you can add paths with .app extensions to the $PATH) but when I restart my Terminal and do echo $PATH | grep Postgres.app I get nothin'.
推荐答案
这是一种寻求帮助来隔离您可能遇到的问题的方法.
Here's an approach to take help isolate problems you may have.
$ export PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH;
$ which psql
如果可行...
在~/.bash_profile的末尾添加以下内容:
Add the following to the end of your ~/.bash_profile:
echo "From bash_profile.";
现在重新启动Terminal.app或iTerm，然后查看是否出现有关您的提示的消息.
Now restart Terminal.app or iTerm and see if that message appears about your prompt.
如果可行...
在~/.bash_profile中:
export PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH;
重新启动您的终端并运行:
Restart your terminal and run:
$ which psql
如果您没有看到:
/Applications/Postgres.app/Contents/MacOS/bin/psql
然后可能是时候尝试将PostgreSQL安装为Mac软件包并使用Homebrew了.
Then it might be time to scrap trying to install PostgreSQL as a Mac package and use Homebrew.
注意:它是psql而不是pgsql.
这篇关于找不到PostgreSQL命令psql，添加到$ PATH时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！