How to install PostgreSQL on Windows 11 | Table Creation using pgAdmin 2024

welcome to another video on my channel in this video we will see how to download and install post SQL after the installation we will create database create a table insert records and retrieve those records let's get started search for postgress SQL open this official web link click on download button choose your operating system System since I am using Windows I will select the windows option click on download the installer you will see several versions of postgress SQL listed select your desired version from the list I will be downloading latest version for Windows wait for the download to get completed okay the download is completed double click to open the installation file press next choose installation directory and press next keep all these options selected and press the next button select the data directory and press the next button provide password that will be used to connect with the database server press the next button this is the default port for postgress SQL press the next button I'm leaving the local as default press the next button here is the installation summary all the option you selected in the previous steps are displayed here review your choices and make any necessary adjustments if any details are incorrect you have the opportunity to go back and modify them once you have confirmed everything is correct press the next button now press the next button one more time to begin installation okay the installation has started we don't want the stack Builder so we will uncheck this option this is an optional tool for installing and managing additional software packages and extensions for post SQL now the installation has completed Open start menu find postgress open this PG admin PG admin is a graphical Administration tool for managing postgress SQL databases provide the password given at the time of installation okay the database server is connected expand the databases we have a default database named post address available here to create our own database right click on the database and select select create then select database name the database and press the save button database created successfully tables are located inside public folder of schema to create a table right click on the public node go to create and select table or you can also right click on the table node directly go to create and select table gift table a name go to column tab to add columns press this add button create ID column select data type as integer make it primary key now click on this edit button here select constraint tab click on identity there are two options for identity I will go with the first one now increment the identity by one press the edit button again to clck close this section now add another name [Music] column the type can be text this has no size limits for a varar with text limit choose character wearing give it length of 50 now press the save button to save the table if you want to add another column to this table right click on the column go to create and press column now to add some data in the table right click on the table and generate the insert script now we will insert data along with ID this gives us error because the ID field is auto increment now just remove the ID data inserted successfully okay let's insert some more data data to view the table data right click on the table go to view addit data and select all rows so the data is successfully inserted this was a very short demonstration of postgress SQL database thank you for watching this video I hope you liked and enjoyed the video please do like like And subscribe to my channel see you next time with some other tutorial

Channel: Dex Code Lab

Views: 234

Keywords: postgresql, pgadmin, what is postgresql, postgresql tutorial, history of postgresql, Database, Clauses, Commands, Queries, Install PostgreSQL, PostgreSQL 15, pgAdmin 4, How to Install PostgreSQL, pgAdmin 4 on Windows 10, PostgreSQL administration tool, EnterpriseDB, how to install postgresql in windows 10, postgresql installation windows 10, pgadmin 4 installation windows, how to use postgresql, postgres tutorial, postgresql create database, postgres, postgresql tutorial for beginners

Id: mZtEKjvUMGo

Length: 5min 36sec (336 seconds)

Published: Wed Mar 20 2024