Обсуждение: How to use pgAdmin 3
Dear Sir/Madam,
I am absolutely new to PostgreSQL pgAdmin. I have no idea how to work on this.
I have currently installed PostgreSQL 8.3.5 win32 version. I need to carry out the following step
--->
Using the Application "PgAdmin III," which was installed with PostgreSQL, login to thedatabase server and create a new database called “connect” with UNICODE setting.
I have been trying to find info from net and do this but in vain. How do I start working with the pgAdmin3 GUI
Kindly guide me step by step how to do this ASAP.
I would really appreciate quick response.
Thanking in advance.
On Tuesday 29 September 2009, manish hiremath wrote: > Dear Sir/Madam, > > I am absolutely new to PostgreSQL pgAdmin. I have no idea how to work on > this. > I have currently installed *PostgreSQL 8.3.5 win32 *version. I need to carry > out the following step > > ---> *Using the Application "PgAdmin III," which was installed with > PostgreSQL, login to the* > > *database server and create a new database called “connect” with UNICODE > setting.* > I have been trying to find info from net and do this but in vain. How do I > start working with the pgAdmin3 GUI > Kindly guide me step by step how to do this ASAP. > > I would really appreciate quick response. > > Thanking in advance. Dear Manish: I work mostly in Linux but I will try to help get you started since I woke up earlier than everyone else! LOL! When you bring up PgAdmin III, click File->Add Server. A dialogue window will appear. The Name: is arbitrary --- whatever you wish to call it and spaces are OK. The Host: is probably localhost since you said both programs are running on the same computer. All the other values are defaults and I believe should work for your installation. When you click OK, PgAdmin III will attempt to contact the database with the information you provided. If it cannot do so, then you need to check: * Is Postgresql running? If not, start it in the Windows->Programs->Postgresql->Start Server or something like that * On Linux, I have to initialize Postgresql with a script. I think Windows does this for you Otherwise, you now have a connection to your database. Click the + sign on the Server entry in the left pane, and a list of server objects will appear ... right click on the Database object, left click "New Database", and a dialogue will appear. UTF8 is Unicode. The "Template" is a model from which to start a database; template0 is fine. Give your database a name and an owner, probably "postgres" as you have not added other users, and that is enough information to create the database. PgAdmin III uses the "right-click menu" -> "left-click select action" paradigm a lot ... that is how you will add columns to your database, etc. Good luck! It is a very satisfying combination, Postgresql and PgAdmin III! Arthur Knight Hammer