Creating Tables and Managing Data

Create via UI

Schemas > public > Tables > Create > Table, then add columns with types, nullability and defaults. Constraints appear on their own tabs with SQL preview.

Create via SQL

The query tool gives exact control:

CREATE TABLE users (
    id BIGSERIAL PRIMARY KEY,
    username VARCHAR(100) NOT NULL UNIQUE,
    email VARCHAR(255) NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

Data Grid Edits

Right-click the table > View/Edit Data to insert, update or delete rows visually. Set Save to persist changes and Refresh to reload, matching server state.

Indexes and Constraints

Add indexes from the table's Indexes tab; FK constraints reference other tables. pgAdmin shows resulting DDL so you learn exactly what was built.

Key Points

• UI wizards and SQL both create tables.
• BIGSERIAL and TIMESTAMPTZ are friendly defaults.
• The data grid edits rows with explicit save/refresh.
• Indexes and constraints are first-class dialogs.