How to install PostgreSQL Zip Archive in Windows

In this example I will show you installing PostgreSQL zip archive in Windows environment. I will show you how to setup username and password for your PostgreSQL database server. I am also going to show you some basic commands for listing all database, switching to another database, creating a new database, showing all tables, creating a new table, database backup, database import. The advantage of installing zip version of the PostgreSQL is that your registry does not get modified and you do not need to restart your system (if required).…

Continue