Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have installed PostgreSQL on a Windows XP laptop so I can learn about using PostgreSQL. My problem is that the PostgreSQL tutorial starts of with the instruction

To create a new database, in this example named mydb, you use the following command:

$ createdb mydb

My problem is that it doesn't tell me how/where to input the command. I have found access to an SQL Shell but it doesn't perform as expected.

What is the 'proper' way to input commands?

No GUI ?

share|improve this question
    
Should I be using pgAdminIII ? –  Nigel Law Jan 5 '13 at 20:06

1 Answer 1

up vote 0 down vote accepted

createdb is a commandline tool which should be run in a Windows commandline window ("Start -> Run -> "cmd.exe"). You have to have PostgreSQL's bin directory in the windows PATH in order for this to work without supplying the full program path.

As an alternative you can run SQL statements using the program psql (which is also a commandline program). You probably also have a start menu entry in the PostgreSQL folder name "SQL Shell" (or something similar) which starts psql directly.

A list of GUI tools (apart from pgAdmin) is available here: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

share|improve this answer
    
pgAdminIII is the answer to my question. I have found a tutorial that explains its functions. I cant post this as an answer yet though :) –  Nigel Law Jan 5 '13 at 20:42
    
I would upvote your answer a_horse_with_no_name but I dont have the rep yet. Thank you anyway :) –  Nigel Law Jan 5 '13 at 21:25
    
I have accepted the answer given realising that there is no one right answer. The command line options will all work but having been used to do everything with a GUI, the pgAdminIII option suits me better. –  Nigel Law Jan 6 '13 at 11:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.