Exploring Databases and Objects

The Object Browser

The tree shows Databases, Schemas, and under each schema: tables, views, sequences, functions, indexes and triggers. Icon badges mark object kinds so structure is readable at a glance.

Properties Panel

Select any object and the right panel shows Properties (columns, types, constraints), SQL (the DDL), and Statistics. The SQL tab is a great way to learn DDL by reading what pgAdmin generates.

Viewing Data

Right-click a table > View/Edit Data > First 1000 Rows opens the data grid; the SQL Settings let you change the row limit. The grid supports sorting, filtering and simple edits.

Dependencies and Usage

The Dependencies tab lists objects relying on the selected one - vital before dropping tables or functions to avoid breaking migrations.

Key Points

• The tree navigates databases, schemas and objects.
• Properties and SQL tabs document each object.
• View/Edit Data browses and edits rows.
• Dependencies prevent painful drops.