From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Browse the server with a graphical interface - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Browse the server with a graphical interface
- [Instructor] In addition to the Command Line PSQL application, we can use a graphical interface to work with our Postgres server. PG Admin four is one of many interfaces that we can choose from and since it comes with our installation it's an easy application to start using. I've gone ahead and pinned a link to my start menu here on Windows. If you're on a Mac you'll find a shortcut in the applications folder. Let's go ahead and start it up. When it first launches, you'll be prompted to set a master password for the application. PG Admin will allow us to connect to lots of different Postgres database servers at the same time, they can be local servers running on our own computer or in a Docker container servers running on our company's internal network or cloud hosted servers anywhere in the world over the internet. By creating a master password here PG Admin will save the individual login passwords to all of these…
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
-
-
-
-
-
-
-