Thread: How to get to command line prompt

I just installed Postgresql for windows.

There is an elephant headed icon, which seems to be the way to get to the command line prompt. I have a textbook which assumes that you can communicate with postgres through command line, and run scripts.

When I click the icon, it asks for password, and then does nothing but disappear.

IF there is no command line available with the windows install, then, is there a 3rd party product? 

Thanks

---

Have a burning question? Go to Yahoo! Answers and get answers from real people who know.

Hi,

Go to Start->run ->  type cmd  <press enter>

say you get the c: prompt then type

C:\blah\blah> psql -U postgres template1

above assumes psql is in PATH. if it succeeds
you shall get a psql prompt.

once you get the prompt , follow the instructions in text book
to create new database , users etc.


regds
mallah.

On 12/8/06, Philippe Salama <karebacnyc@yahoo.com> wrote:
> I just installed Postgresql for windows.
>
> There is an elephant headed icon, which seems to be the way to get to the
> command line prompt. I have a textbook which assumes that you can
> communicate with postgres through command line, and run scripts.
>
> When I click the icon, it asks for password, and then does nothing but
> disappear.
>
> IF there is no command line available with the windows install, then, is
> there a 3rd party product?
>
> Thanks
>
>
>  ________________________________
> Have a burning question? Go to Yahoo! Answers and get answers from real
> people who know.
>
>