109. PostgreSQL DBA: How to install pgadmin 4 on Windows 10/11 | pgadmin 4 install on Windows | 2024

hello guys in this video we will see how to download and install PG admin that is process SQL GUI tool for on Windows operating system the process is same for all Windows operating systems go to PG admin official website that is PG admin. orc see here PG admin is the most popular feature Rich open source Administration and development platform for post SQL the most open source database in the world okay so click on download see here we have downloads for Mac AP that is for debn type operating system RPM that is for Fedora Red Hat type families of Linux dto okay then Windows okay so click on this Windows see here the latest stable version at the time of making this video is Fe admin 4 and vers is 8.3 okay it is released on fe9 2024 click on this pj4 4.4 8.3 to download click on it click on the C PG admin x64.exe file it the size is 181 megabytes click on it see download has been started go to downloads see here it is 182 mbes wait until this download completes see download is completed click on this PG admin exe file here we have to select the install for me or install for all users anything is fine based on your requirement click on it see the message here this will install PG admin 4 version number 8.3 Okay click on next check this I accept the agreement and click on next see this will be the destination location of for PG admin click on next click on next click on install see installation has been completed successfully click on finish open PG admin go to start all programs see here we have the PG admin for application click on it see this is the pjm for console this on help check the about PG admin 4 see this is the latest version now we will see how to add or connect to the PO equal server click on add new server or or expand servers see we don't have any server right click and click on register then select the server both are same okay so click on add new server here we have to provide the name name can be anything pg1 16 here in the drop down we have we don't have any other server groups click on connection here we have to provide the host name or IP of the post SQL where it is installed see I have installed post SQL on my local PC so you local host or IP of the mission you don't know how to find the IP go to start CMD then ip config scroll see this is my IP 4 see IP 4 is the address okay then maintenance database see M by default every post equal server contains this post not only this you can give any database which is exist on postal then provide the username username also same you can get the list of the users from the psql shell let me show you psql slash see these are the users available in my PC okay then provide the password of the user then you have to click on Save if all these settings are correct then we will be able to connect otherwise it will throw error also see the port number this is the port number for the post SQL now here we can give local poost or any remote IP also like AWS RDS dnsr IP or full name server name also for aure database for post SQL also we can do here here okay click on Save see we have successfully connected here we got the system see these are the session details okay so expand this one expand databases see we have three databases go to there /l see here we have six data five databases but it is here it is not showing template zero and template one okay it is by default okay so here if you want to execute queries select the database right click and click on query tool or just select the database and click on query tool both are same now we can write the queries like create lab test TN in [Music] primary select the text and click on this execute button this is the button to execute query from the PG admin or use F5 from your keyboard both are same click on execute once we execute this one here we will get the output see it is created table okay we want to verify the data just again select start from test select the query and click on execute see we don't have any data here data output it will show the output here it will show the total query run time it is 21 milliseconds you want to comment these commments in PG admin use control then forward SL C these are commented to also if you want to make this to Capital go to file preferences then scroll down here we have the options like Auto completion It Is by default disabled squ formatting result grid okay we can set up all the options like display everything we can set up graphs also see we have different options based on your requirement you have to select them see SQL formatting if you want uppercase you have to give expression with everything go through them and you can configure here we can also create database by using right click on that and create database and table also we can create by using go method in right click create table click on it here we have to provide the name for the table T1 then columns provide the columns by clicking on this add row D1 here select the data type any of this integer then if you want null values if you want to make this primary key you have to provide and you want to provide default values you have to provide and click on save so it will create the table even constants we have we can give here you want to provide the constants information click on this plus symbol foreign key primary key check constant un constant exclude okay if you want to see the query of this select statement this is the query and one more see this is the owner of this table and this is the schema so I have only one one schema you want to provide the table space you can provide if you want to provide comment see you can provide here okay partitions also same so click on Save see table is created also you can create schemas also right click on schema select it and click on schema in the same way if you want to create users right click on this login on users click on login or group Ro then we can provide the login name privileges membership parameters and here it will show the syntax for the operations or permission that we are going to create for this create roller l log okay I'm not going to create just I have in this also we can open the psql also psql tool see here we can perform the same operation like how we are going to perform here okay so see PS shell version is 16 and server version is 16.1 and see here it is giving the host name Local Host port number 5432 DP name after schools usern name is post okay because we have selected AR that's why it is saying this one we want to change the database name right click on post and select PSL now see the DB name has been changed to post okay so in this video we have seen how to download install and configure PG admin 4 on Windows 11 operating system the process is same for all Windows operating systems then we have seen how to create objects in post SQL Server by using J Tool that is jmin 4 for more post videos please subscribe my channel thank you

Channel: r2schools

Views: 575

Keywords: How to setup pgadmin 4 on Windows 11, How to setup pgadmin 4 on Windows 10, How to install pgadmin 4 on Windows 11, How to install pgadmin 4 on Windows 10, How to install pgAdmin 4 in Windows, Install pgadmin 4 on Windows, Install pgadmin 4 in Windows, pgAdmin Installation on Windows, postgresql gui tool, PostgreSQL GUI tool pgadmin, PostgreSQL Tutorials, PostgreSQL Tutorials for beginners, PostgreSQL Tutorial for beginners, PostgreSQL DBA Tutorials, pgadmin 4 for Postgresql

Id: uiIggZ-ZkaA

Length: 10min 4sec (604 seconds)

Published: Sat Feb 17 2024