How to open postgres command Line?

Question

I have postgres installed.How to open postgres command Line? When i open command prompt, i have

Microsoft Windows [Version 10.0.17134.590]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\dhanr>

How to navigate to postgres command Line, as my final goal is to run pg_dump dbname > outfile command.

You need to have postgres executable on your Path.

Sid
– Sid

2019-02-23 05:56:14 +00:00
Commented Feb 23, 2019 at 5:56 — Sid
– Sid, Commented Feb 23, 2019 at 5:56

Wai Ha Lee · Accepted Answer · 2019-02-23 08:27:55Z

7

You should use psql command-line tool.

You can find psql at your installation directory. Example;

C:\Program Files\PostgreSQL\10\bin\psql.exe

edited Feb 23, 2019 at 8:27

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered Feb 23, 2019 at 6:00

grep

5,64112 gold badges67 silver badges115 bronze badges

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

Comments

Zaynul Abadin Tuhin · Accepted Answer · 2019-02-23 05:56:07Z

1

Go inside bin folder in C drive where Postgres is installed. run following command in git bash or Command prompt: pg_ctl.exe restart -D "" Ex: pg_ctl.exe restart -D "C:\Program Files\PostgreSQL\9.6\data"

Another way: type "services.msc" in run popup(windows + R). This will show all services running Select Postgres service from list and click on start/stop/restart.

answered Feb 23, 2019 at 5:56

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

1 Comment

Dhanraj Over a year ago

Thanks for you answer.It will restart the service.. I was looking for command Line

Collectives™ on Stack Overflow

How to open postgres command Line?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related