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

Create objects with pgAdmin's dialog workflows - PostgreSQL Tutorial

From the course: PostgreSQL Essential Training

Start my 1-month free trial Buy for my team

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…

Contents