PostgreSQL TutorialLesson 5Free preview

PostgreSQL pgAdmin 4

This lesson is part of PostgreSQL · All levels

Summary

PgAdmin 4 is an official graphics application for managing PostgreSQL servers, available as both desktop applications and servers that are opened via a browser. With pgAdmin you can register servers, browse databases and tables, and write queries to the Query Tool. This tool is very helpful for beginners because all operations are visually visible.

Key points

PgAdmin 4 provides a view of the server tree, database, schema, to the table.
Register Server is used to add connections to the host, port, username, and password.
Query Tool displays the query results directly in table form.
Use Tools > Query Tool to write SQL without moving to the terminal.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.