From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Tour the pgAdmin interface - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Tour the pgAdmin interface
- [Instructor] Before we dive into working with the PostgreSQL server, let's take a quick tour of the pgAdmin interface. On the left hand side of the screen is a tree view of the database servers that we've connected to. Depending on the version of pgAdmin that you're working with, this area may have two different names. In version six and earlier this pane is called the browser. Version six is the version that I'm working with now. And it's the version that's currently bundled with the unified installer that I got from EnterpriseDB. If you've downloaded pgAdmin as a standalone application, it's likely that you'll have a slightly newer version seven. Starting in version seven, this pane is called the object explorer. Either way though, they do the exact same thing. At the top is the server group container. You can create multiple server groups to organize your connections by right clicking on the existing group, pointing to…
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
-
-
-
-
-
-
-