From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Create objects with pgAdmin's dialog workflows - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Create objects with pgAdmin's dialog workflows
- [Instructor] The PG admin graphical interface provides a number of dialogue based workflows for accomplishing common tasks. This saves us from having to write out the SQL commands ourselves like we did on the command line. I'd like to create a second database using these dialogues here in PG admin so that we can compare the two different working environments. First, expand the service collection and find your database server, right click it, point to create, and then click database. That opens up the Create database dialogue workflow. Now, the only thing that we absolutely need to fill in here is the database name. Let's make a database to store information about various fruit. Technically, that's all we need. If I press the save button now, Postgres would create the files and set up my new fruit database. But by simply exploring the interface we can see that there's lots of different configuration options that we…
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
-
-
-
-
-
-
-