So after installing postgresql we are ready to start using it. The admin tool pgAdmin III was installed without my knowledge - thank you Postgresql :) - it was just a matter of starting it from the Start menu.
Pretty much like any other database admin tool I'd say. If you have used Enterprise Manager or SQLYog you will understand it pretty much instantly.
Creating the Postgresql database
Please note that I am no Postgresql expert - on the contrary I am a total novice - but here I am explaining the steps I took and some of them might be totally stupid. But intuively - in this New database dialog, I felt that permissions should be defined somehow, so I (on the Privileges tab) gave public All priveleges. No idea if that is needed or not - or a good thing to do.
Anyway - now we should create the table:
Create the Postgresql test table
After selecting New table - we should define columns. Here I noticed some different stuff as compared to MSSQL and MySQL. I wanted to use a identity/autonumber field. I had to google it up - in Postgresql it's called Serial:
After a while I had created this structure:
In the Contraints tab we can set id to be primary key. I also called the table TESTTABLE (we are gonna use it in next article)
More on the admin tools
It contains a pretty decent query tool as well:
And a functional GUI data editing tool (so we don't have to write insert/update statements all the time):
