How to Install PostgreSQL on Windows 10/11 [ 2024 Update ] pgAdmin 4

hello everyone I welcome you all to gy script  today in this video I'm going to show you how   to install post gr SQL on Windows operating system  and after that I'm also going to show you how we   can easily use post G SQL interface then how  to create a database how to create table how   to insert data how to you know F all the details  from your table all that on this video so this   video might be a bit long but I can guarantee you  that if you stick with this video till the end   you'll be able to learn a lot of new things and  if you face any issues in Middle you can always   put a comment in your comment sessions I'll try  my best to help you right so without any delay   let's start our video now to install post G SQL  you need to First simply go to favorite browser   and to just simply type over here post gray  SQL download and hit enter and you'll be able   to see this you know post SQL download link  in Google search so just simply open that and   it going to redirect to the official site of  post GSL so this link I'm going to put right   in our description so you can directly use that  link and you can you know proceed with whatever   operating system you're using So currently it  is showing Linux Mac W Windows you know solares   and all that so I'm going to choose Windows  as I'm installing it for Windows but you can   choose you know as per your operating system so  let's click on Windows and you can see that our   letest version is version 16 so you can just you  know simp click on this link over here download   the installer link and when you click on that  it going to you know redirect to this site EB   and that is basically Enterprise DB and here  if you see lat version is 16.1 and this is our   Link for Windows can see it likly started to  download right there you go so I have already   downloaded it so I'll cancel this I'll minimize  my browser I'll go to my download directory and   you can see that our post GQ is already been  downloaded over here and the file size is 361   MB right so it just simply double click on the uh  installer to install it locally on our system and   it going to ask you that the app that you're  trying to install isn't a Microsoft verified   app which is totally fine you can totally trust  our post gql so just install it and it will ask   you for administrative privilege just simp click  on yes and let's minimize our download directory   so welcome to post gql and there you go so this is  our post gql installation setup just simply click   on next over here so this is where our post gql  is going to be installed which is totally fine if   you want to change you can do that by just simp  clicking on this button right you can choose any   folder from here but I'm going to keep this  default which is this one itself and click on   next and these are the things that it going to  be installed so you can see that it will install   the post SQL Server which is the most important  part so the post SQL Server is the one where we   will be you know creating our database table and  everything so that is our server and PG admin 4   is basically give you a graphic user interface  so again that's a important part and I'm am also   going to install stack Builder and I'll quickly  show you a bit overview about stack Builder I'm   not going to talk much but I'll just give you  overview about what is tag Builder and all and   common line tools is also selected so basically  keep everything default click on next over here   and uh this is going to be our data directory  folder again I'm going to keep this default and   click on next so here is the part to give the  password so let's give a password you need to   remember this password to login every time on our  post s right so just simply give a password and   this is our port number 5432 is our port number so  again this is very important so that password that   we have given earlier screen and the port number  is what you know we use to connect our front end   code with our backend database so that's these  two are really important you need to remember   and click on next so you know Advance option I'm  going to keep this default I'm not going to change   anything just simply click on next and it's ready  to be installed click on next next and install so   you know installing this will take some time a  couple of minute so by the time it get install   I'm also going to talk about you know my this new  channel called geeky syntax so here I'm going to   post regularly coding related videos so please  do subscribe this channel so that will you know   motivate me to make more coding and programming  videos on this channel and I have started just a   vlogging Channel if you're interested you can also  subscribe our vlogging Channel as well all right   so let's minimize and you can see it is in started  installing so this installing our post guq will   take some time you know about 5 minute I can say  so you know let's wait for some time once we are   done installing our post Gaz I'm going to again  back to this video yep so we'll come back and now   you can clearly see that our post SQL is almost  installed and it is asking whether you would like   to open stack Builder so you know I'll quickly  uh give you a bit overview about stack Builder   so just simply click on finish and it will show  you this welcome to stack Builder so here let's   click on this drop down and click on post SQL  16 so on Port 5432 right just simply click on next and you can see you know the list of some  categories so here you know if you expand this   you know database drivers you'll be able to see  some of the drivers over here as I was telling   you if you if you want to connect with your front  end code with your back end you need to have you   know some sort of driver I need to provide  your username password and Port you know all   that into that configuration to establish that  connection between your front end and back end   right so that also requires one driver right  so from here you can install such drivers so   you need to select that and you to proceed with  the next button to install it right so if you   are willing to you know know more about these  drivers how to connect with our front end code   with our backend so all that if you need please  put a comment in your comment sections I'll be   happy to make videos on that as well all right  so how to install driver how to establish that   connection and all that so similarly you can also  expand database server so you can install any of   the server from here currently we have installed  the latest version which is version 16 but maybe   the project that you are using might required  version 13 or 14 right so from here you can   downgrade your you know database server version  from here so similarly we have lot of options I   I don't want to you know go deep into all this  I'll just simply cancel this for now yes so now   what I'm going to do is I'm going to quickly jump  over to you know our PG admin so just simply type   PG admin you'll be able to see this PG admin 4  over here say so just simply open that PG admin 4 and you can see that our PG admin 4 is ly opened  over here so let's expand our servers so it will   ask you about the password that you have given  so repeat that same password and click on save   password click on okay so when you do that  you can see that it is rightly connected now   so here is our Pros Gaz SQL Server 16 and here  is our database so let's expand our database   so we have this post s datab which comes with the  installation okay so to create a new database you   need to click on this database then right click  and you need to you know hover over this create   and you'll be able to see this database so just  simp click on that and it will open this create   database window so here I need to give a database  name so I'm going to give the uh database name as   test DB okay and all other things are fine if you  want to you know Set uh uh the encoding Style or   the security so you can do all of that here and  here will be our script so which will be you know   actually running in the back end so you know  just simply click on Save and it going to you   know create a database so here you can see we have  a test TV now created successfully right so here   you have lot many options like triggers and all so  triggers are a bit uh you know on the higher side   so if you want you know videos on in know SQL then  please put a comment in our comment sections I'll   try my best to make more videos on SQL as well so  there I'm going to you know discuss about plsql   triggers uh functions store procedure and all  those things so if you need you can uh comment   all right so for now what I'm going to show you  is this schemas so if you expand this you'll be   able to see this public and on that public here  can see we have tables so you know to uh so if   you expand this table right now you can see we  don't have any tables right so how to create table   so just simply you know right click on tables  and over over create and click on table so this   will you know open this uh create table window so  here let's give the table name as employee and uh   you know uh this table space and all are fine so  just simply switch over this column and here you   can add column so you need to click on this plus  icon and here you can give your column so let's   give the column as ID and it will be of uh integer  type and uh let's create one more you know column   so let's give the column name as full name and it  will be character all right so now it is fine you   can set the length to 50 characters all right so  just simply click on Save and it going to you know   create our table so here you can see under tables  we have now a employee table so if we expand this   you can see that uh our table is successfully  created and if you expand a column you can see   those two column that we have created ID and full  name is successfully created over here all right   so if you want to you know write your own script  to create table so that you also you can do you   can just simply you need to click on this test DB  your database name basically and then you need to   click on this query tool so when you click on that  it's going to open this you know query window over here so here you can write your own  script all right and uh I'll go to this employee and I'll hover over the scripts  to write a insert script so when you click   on that it going to you know again open a  query window so giving a template of our   insert statement so here and let's give  a couple of values so one uh will be our   ID and name will be our and know Rahul  draid so I'm just giving one name I'll   just simply select this and I'll click  on this run button and it going to to run uh this Rahul will be within single  code this rul D name fi all right so you   can uh you know select this again and  click on run button and you can see that   our qu return successfully so it is you  know successfully inserted on our table   so similar way let's insert one word value  like two and give the name as Rohit Sharma and select this and execute and you can see it has  again successfully executed so now a overover over   employee again right click go to script and this  time write a select script so the again this will   give you a select script uh query window so you  can see select ID full name so fine just simply   execute this from our employ Loy table and you  can see those couple of entries that we have   done previously Rahul David and rohil Sharma are  rightly inserted on our table employee okay and   you can easily retrieve all that so in this way  you can easily install latest version of post G   sill that is version 16 on Windows operating  system and after that I have also shown you   how to use this you know PG admin uh graphic user  interface to you know insert dat database create   table column how to write queries how to F and  all that so if you need more tutorials please   put a comment in your comment sections I'll try  my best to make more tutorials and don't forget   to like share and subscribe that will really  help me to make more such videos so that's   basically all about this video thank you very  much for watching this video and God bless you all

Channel: Geeky Script

Views: 13,815

Keywords: postgresql, pgadmin, what is postgresql, postgresql tutorial, history of postgresql, Database, Commands, Install PostgreSQL 16, pgAdmin 4, pgAdmin 4 on Windows 11, PostgreSQL administration tool, how to install postgresql in windows 11, postgresql installation windows 11, pgadmin 4 installation windows, how to use postgresql, postgres tutorial, postgresql create database, postgresql 2024, postgres, postgresql performance, postgresql tutorial for beginners, How to install PostgreSQL

Id: uN0AfifH1TA

Length: 14min 1sec (841 seconds)

Published: Thu Jan 18 2024