GUI tool for PostgreSQL

Mainly for development, debugging, inspection.

• Connect to Postgres servers
• View databases & tables
• Run SQL queries
• Create / edit tables
• Inspect indexes, constraints, users

Action in pgAdmin:

• Add existing server:
  • Servers → Right click → register
  • Host: localhost
  • Port: 5432
  • Username: postgres
  • Password
• Create DB
  • Databases → right-click → Create
• Create table
  • Schemas → public → Tables → Right-click → Create → Table
  • General tab: table name
  • Columns tab: define fields
  • Constraints tab: PK, unique, FK
• Run SQL
  • Tools → Query Tool
• View data
  • Right-click table → View/Edit Data

Setup