and this video will look at how to download and install postgres sql database on windows system
so here i have windows 10 system so we'll install on windows 10 system
but you can follow the same process for other windows version let's get started
so first we'll download postgresql database so for that let's open our chrome browser
and here in the search bar search for
post create sql
so once you search for postgresql download here you can see the
official website of postgresql so just click on it
so once you click on this one here in the next page you're gonna see the
postgame downloads and here we have support for linux makes os windows and solaris and bsd
systems so we're going to install on windows system so let's click on windows
so once you click on the windows okay here you can see the version of sql so right now we can
see the 1013 and here we have link something called download installer so just click on it
so here in the next next page you will see this uh database was in 13.4 as a latest version
and here we have windows 64-bit and here you have this download button so just click on it
so now you can see our postgres database download is started this may take a while
and we'll wait till download is completed and will resume our postgre sql database installation
so it's look like our download is completed so now let's go to download folder
and here you can see the exe file for our postgres sql database so for installation just double click
on this exe let me minimize all the stuff so our postgres sql database installation is started and
this is our first phrase of our setup so here it says welcome to postgresql and just click on next
and here it you can see this is gonna install under c program file program sequel 13
and if you want to change this path and if you want to say save some merit to your uh
d drive or e-drive you can click on this button and you can change it but yeah i'm
gonna go with this default one and just click on next so here it says uh all this component
the postgresql server pg84 stake builder and command line so it's gonna install all this for
software and now let's click on next and here this is my data directory it's under c
program file prospects equal 13 and data so let's go with the default for this as well and click on
next and here you gonna set up the password for your postgresql so let's set the password
yeah make a note of this password because you're gonna need this password when you log in into your
postgresql database so just make a note of this password and now let's click on next
and here this the port number it says 5432 let's go with the default and click on next
so here we go with the default and click on next yeah we are ready to install this postgres sql
and just click on next so now it says setup is now ready to begin installation postgre
on your computer so let's click on next and our installation process is started
so let's wait till the installation process is completed and we'll resume our video
so our installation process is completed and here we have checkbox call
the stake builder may use to download and install additional tools driver and application to be
complement your postgre installation so yeah we are not going to install any
driver or any tools so just uncheck it and click on finish
so now let's open the pg admin to connect to our postgre database so let's yes for
pg admin so here we have pj admin 4 so just click on it
so this will uh launch your pga admin
which is nothing but the management tool for your postgres sql database so our pc admin is open and
here we have to enter our password which we set while installation so let's enter our password
and say ok and here you can see the servers now let's expand the server
and when you expand that it will try to connect to your server so when you
try to connect to your server you have to enter your password so let's again enter the password
and say save the password and say okay
so here uh we have something called database so let's expand this database and this is our
dashboard where you can see all this activity uh on your postgre database uh here you have sql
so which is the console to write the sql and here by default you can see this your one database
called postgre so now let's create our own database so right click on database create data
and here you have create and click on database so now let's give our database name so i call it
mydb and if i go to the sql i can see the syntax for this creating the database so it
says create database then database name with all this other features sorry options and now say save
so our database is created here you can see mydb
so when you click on this one by default it will be connected to my db and here you can
see this all those things now let's expand the schemas so here you can see your public schema
and in public schema you have this views tabs tables so let's expand the table so
you don't have any tables so right now let's right click on table and say create table
so here i see
my table
maybe tbl and let's enter the column so i say head so here i see
a so let's select integer and say save it so you can here you can see my table is created
so now if you want to query your table so just right click on this one and say query tool
so here you see select
star from
my tbl now let's select this and say
execute
so here we don't have any record so we cannot see
any record now let's insert some records inside this table so i say
insert into my tbl and break it i say one and
now let's execute it i think we have to enter the values
and now let's execute this
so one row is inserted now let's enter the second one
so second row is inserted into our table now let's delete this and now let's say select
start from table and let's execute this so here you can see this two record one and two
so this is how you can create the table inside postgres sql database and yeah that's all for
postgres sql database installation process hope this video will help you to install possible
sql database on your windows system and thank you for watching this video and see in the next video