pgAdmin graphical interface overview in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is pgAdmin in PostgreSQL?

pgAdmin is a graphical user interface tool that helps you manage PostgreSQL databases easily without using the command line.

beginner

Name the main sections of the pgAdmin interface.

The main sections are: Browser panel (left side), Query Tool (center), Dashboard (overview), and Properties panel (bottom or right side).

beginner

What is the purpose of the Browser panel in pgAdmin?

The Browser panel shows your servers, databases, schemas, tables, and other objects in a tree view to help you navigate easily.

beginner

How do you run SQL queries in pgAdmin?

You open the Query Tool from the Tools menu or right-click a database, write your SQL commands, and click the Execute button to see results.

intermediate

What information does the Dashboard in pgAdmin provide?

The Dashboard shows server activity, database size, sessions, transactions, and other performance metrics in graphs and charts.

Which panel in pgAdmin shows the list of databases and tables?

A Properties panel

B Query Tool

C Dashboard

D Browser panel

The Browser panel displays the tree view of servers, databases, schemas, and tables.

Where do you write and execute SQL commands in pgAdmin?

A Query Tool

B Browser panel

C Dashboard

D Properties panel

The Query Tool is designed for writing and running SQL queries.

What does the Dashboard in pgAdmin NOT show?

A Database size

B SQL query editor

C Server activity

D Performance metrics

The SQL query editor is in the Query Tool, not the Dashboard.

How can you open the Query Tool in pgAdmin?

A Right-click a database and select Query Tool

B Click the Dashboard tab

C Use the Browser panel to drag tables

D Open the Properties panel

Right-clicking a database and choosing Query Tool opens the SQL editor.

Which of these is NOT a feature of pgAdmin?

A Visual monitoring of server performance

B Graphical interface for database management

C Command line tool for PostgreSQL

D SQL query execution

pgAdmin is a graphical tool, not a command line tool.

Describe the main parts of the pgAdmin interface and their roles.

Think about where you find databases, write queries, and see server info.

Explain how you would use pgAdmin to run a simple SQL query on a database.

Focus on the steps from opening pgAdmin to seeing query output.