From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Use pgAdmin’s toolset - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Use pgAdmin’s toolset
- [Narrator] Now that the browser tabs are cleared out, I'd like to turn your attention to these buttons at the top of the tree pane. Let's make sure that we have the colors table selected over here in the sidebar, and that'll activate all of these buttons and we can move through each one. The first one is called the query tool. If you hover your mouse over it, you'll see the shortcut. On a pc, it's Alt + Shift + Q, and on a Mac, the shortcut is Option + Shift + Q. The query tool gives us a new browser tab where we can write and execute our own SQL commands on the server. You'll write the SQL code up here at the top, and the results will display in the bottom pane. When you're done with the window, click on the X in the upper right hand corner to close it. You'll be prompted to save any scripts that you've written, which can make it easy to work on a complicated routine and save your work for later. The next button over is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
What is PostgreSQL?4m 59s
-
(Locked)
Download and install PostgreSQL7m
-
(Locked)
Install PostgreSQL with Docker5m 34s
-
(Locked)
Connect to the server with psql8m 4s
-
(Locked)
Browse the server with a graphical interface5m 19s
-
(Locked)
Connect pgAdmin to Docker4m 35s
-
(Locked)
Tour the pgAdmin interface4m 48s
-
(Locked)
Use pgAdmin’s toolset5m 31s
-
(Locked)
Create objects with pgAdmin's dialog workflows5m 56s
-
-
-
-
-
-
-