Working with the database Part 2/2

pgadminI hope you have installed pgadmin3 from my previous post .

Now open pgadmin 3.

Add a connection to server by clicking the first option in the top of the window.

Add the details as added in the below snap:

Server Registration
Server Registration

Name is the name of the database.

Host is our localhost which is setup at 127.0.0.1

Port can be left as 5432

Maintenance DB and username is by default postgres

Add the password you have given in the postgres setup in the password field.

Click OK and you are done with server connection.

Go to the database you have created and start exploring through SQL queries.

Thanks for reading.If you have any issues/doubts,feel free to comment or drop me a mail at geojoyce934@gmail.com

Have a nice day.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s