pgAdmin Tutorial – How to Use pgAdmin
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=67
🎓 Learn and become confident in SQL: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=67
pgAdmin is a popular SQL editor for Postgres. It comes installed with Postgres and works on both Windows and Mac.
Learn how to get started with pgAdmin and how to use many of its features in this video.
Timestamps:
00:00 Introduction and download
02:06 Open pgAdmin and enter master password
02:40 Main window
03:28 Create new connection (server)
04:58 Toolbar buttons
05:37 Query tool
09:01 Save and open queries
09:34 Edit button
11:00 Explain plan
12:46 Search for objects
13:22 Other features
14:20 Preferences
by Database Star
linux web server
Thanks for this video
Awesome and to the point. Thanks for taking the time to record this video.
what is the password?
Thanks for covering this specifically for POSTGRESQL. I wish you would cover some more Database related material. Keep up the Good Work. 👏🏼
Hey, pgadmin has a web version?
Simple, easy and to the point. Thank you very much!
thanks for your video
Can you not see data in your tables as a table and have the ability to click a cell and change the data like that? Does viewing and modifying data in the tables require you to write a sql query, or can you click and change it in some other view?
Simple and concise, perfect!
very nice
Thank you so much👍👍👍
Thank you
Mine didn’t request for password and I can’t set up 😊
Unable to connect to server: connection to server at "localhost" (:1), port 5432 failed: Connection refused (0x00002740/10061) Is the
Error 😞😢
server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed Connection refused (0x00002740/10061) Is the server running on that host and accepting TCP/IP connections?
Thank you for this introduction to pgAdmin. It is very clear and concise !
Very nice video. Thanks a lot for your help!
Thank you!
Pg admin not asking master password how to fix this?
I'm impressed.
A detailed yet easy to understand tutorial.
how to delete the adminstartor user in pgadmin
it didnt ask me to set a master password i dont know why
Very concise and helpful!
Great guide. Still can't even create the PGAdmin server on localhost due to a timeout error regardless of anything I do, but at leat I can understand my school lab now. Thank you!
Exactly what I was looking for, thank you.
Please I need ur assistance urgently, my PostgreSQL refused to open after Mac update, I have uninstalled and reinstalled still not working
Woohoo thank you so much, very clear and to the point.
thank you. it was really helpfull.
Thank you it's very helpful! keep up the good work.
what should i do if it doesnt ask me to set up a master password when i open it?? how can i set it up????
Very crisp, well presented. Thank you!
thanks for this. really appriciated
How to use Scratch Pad?
very helpful! Thanks.
great video, audio is very quiet though
Thank you for being clear and concise.
great! clear presentation to understand step by step.Wishing you all the best.
In my pgadmin data type length is not shown ……How can I see the datatype length like (VARCHAR(30)) along with attribute name in table…….
Thanks for the video, helped a lot!
Thank you very much for this well explained and quick tutorial! It is logical, helpful and gets to the point. By far the best pgAdmin tutorial I found.
When I create a table on my Mac, pgadmin doesn’t show me my table on the left side can someone help me please
Thank you, this was very helpful!
Best video on pgAdmin. Thank you!
Yep. This is very useful video. It clearly describes the process of connecting to a database and explains all the dialog boxes.
Is there a part 2?
Exactly what I needed and more! Thank you so much! 🤗