How to Download and Install PostgreSQL and PgAdmin 4 for Windows 10/11 2024

hi everyone in this video I'll be showing you  how to download and install postgreSQL along   with PGadmin so let's get started so first thing  just go to Google and type postgreSQL download   you'll be getting the first link postgreSQL dot  download just click here and here we'll be having   the options to download for different operating  system this video is going to be for Windows so   I'll just click on Windows and if you scroll  down we'll be having the different versions   of postgreSQL and at the top you'll be having the  download the installer option click here and this   will give us the different versions for Linux  Mac and windows and we are going to do it for   Windows so let me go with the latest version and  the download will be getting started it is about   363 MB in size so just be patient till then once  the download is complete just double click and   open it and you'll be getting the postgreSQL  setup just click here next and this is going   to be the location where postgreSQL is going to  get installed if you want to change this you can   just click on this and change it once you choose  your location just click on next and make sure   that you are checking all these four checkboxes  so we are going to install postgreSQL Server   PGadmin stack Builder command line tools so don't  uncheck any of these and just click on next and   this is going to be the data directory this is  fine don't mess around with that just click on   next and here is the most important thing you  need to enter the password and make sure that   you are remembering this password okay so let me  just type my password just click on next and this   is going to be the default Port I will leave it  to the default one next and this is fine next and   just click on next yeah the installation is ready  just click on next that's it will take some time   for the setup to install once it is done there  will be a checkbox saying stack Builder Maybe   used to download and install additional tools so  just check this and click on finish and this is a   stack Builder thing and if you just click on  this and select postgreSQL and just click on next and you can just download many add-on tools  for example we can download these so these are   like kind of drivers and plugins if you want you  can just add it out so this is just optional for   now let's just close this yeah just click on yes  now if you just go to search and type PG you'll   be having this PG admin 4 just click on open so  you'll be getting an interface like this PG admin   management tool for postgreSQL and to the left  you will be having this servers option just expand   this and it will ask you to enter the password you  need to enter the password which you entered while   installing postgreSQL so let me enter mine and  make sure that you're checking this save password   so that you don't want to like re-enter it again  and again and just click on okay and now you'll be   getting these options one is databases login roles  and table spaces so let me just expand databases   by default we'll be having the postgres database  automatically created so if you want us to create   a new DB right click on database click on create  database and here just name your database let   me go with demo DB and you can just modify the  definition security other parameters and we'll   also be getting SQL query okay so basically we  are creating the database through this interface   so if you want to create it through a query you  can just run this query that's up to you and just   click on Save and here you can see I'll be having  my demo DB over here and now let's see how we can   create a table in our demo DB so under schemas we  will be having option called as public and under   that we'll be having tables so if I expand it  nothing will be there because we haven't created   any tables so if you want to create a table  there are two ways one is right clicking this   and just click on create table here you'll be able  to specify the table name and add the columns and   its data types if we click add you can just add  a name and you can just select the data type and   you can just click on Save the table will be  getting created so this is the one way let's   click on yes another way is going to be through  writing queries so we'll be writing an SQL query   over here so to get the interface to write a  query right click on the database itself and   you'll be having this query tool so we will be  getting a space to write our query so I already   have my query ready just a normal SQL query to  create a table so for running this you'll be   having execute script run it so I'm getting query  returned successfully and just go to your demo DB   database right click and refresh so that we are  getting the table in our schemas so now if you go   to schemas and if you go to tables here you can  see I'm having the table named student and if I   go to columns I'm having name and ID exact same  thing that we gave over here so which means that   our postgreSQL is working fine so that's the video  guys do check the playlist of my channel done   a lot of videos in programming MySQL queries  mongodb queries CRUD operations AI tutorials   openAI Gemini AI APIs so check the playlist  of my channel subscribe me thanks for watching

Channel: United Top Tech

Views: 5,328

Keywords: download postgresql and pgadmin for windows, install postgresql windows, install postgresql and pgadmin in windows, postgresql pgadmin 4 download, postgresql tutorial, postgresql download, pgadmin 4 installation windows 11, pgadmin 4 installation windows 10, pgadmin 4, postgresql, How to Install PostgreSQL, how to install postgresql in windows 10, pgAdmin 4 on Windows, postgresql download for windows

Id: 4qH-7w5LZsA

Length: 5min 25sec (325 seconds)

Published: Sun Apr 14 2024