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: www.databasestar.com/pgadmin-...
📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: www.databasestar.com/sql-road...
✍️ Learn how to design a database: databasestar.mykajabi.com/edd
📧 Contact me here: www.databasestar.com/contact/
📝 Database Design Exercises: bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: bbrumm.gumroad.com/l/oqggau
Негізгі бет Ғылым және технология pgAdmin Tutorial - How to Use pgAdmin
Пікірлер: 151