pgAdmin Tutorial - How to Use pgAdmin |
|
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 RESOURCES: Get a free pgAdmin Cheat Sheet here: https://www.databasestar.com/pgadmin-cheat-sheet/ π Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/ π§ SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-roadmap/ βοΈ Learn how to design a database: https://databasestar.mykajabi.com/edd π§ Contact me here: https://www.databasestar.com/contact/ π Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi π SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk π SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny π Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau |