pgAdmin 4 Tutorial

The PostgreSQL Admin Platform pgAdmin 4 is the most widely used open-source administration tool for PostgreSQL. It gives developers and DBAs a graphical web interface to servers, ...

Install Options Windows - The PostgreSQL installer from EnterpriseDB bundles pgAdmin 4. Linux/macOS - distro packages or pip. Docker - dpage/pgadmin4 image for server mode. First ...

Add a Server Right-click Servers > Create > Server, then in the Connection tab fill: Save. The server appears in the tree with databases below it. SSL and Advanced Options The SSL ...

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 ...

Open the Query Tool Right-click a database > Query Tool, or press the SQL icon. A large editor opens with tabs and an execution toolbar. Write and Run F5 (or the Play button) ...

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 ...

Export via the Grid Run a query, click the Download/Export icon in the results, choose CSV, delimiters, and quoting. Export honors the query filters, giving filtered reports ...

Backup a Database Right-click the database > Backup. Choose a file location, format (Custom is the flexible default), and press Backup. A "Custom" dump is compressed and ...

Dashboard Click a server to see the Dashboard with sessions, transactions per second, cache hit ratio, and tablespace usage. It refreshes live, so load spikes become visible. ...

Security Best Practices Force SSL on remote connections. Store the master password in a password manager. Create role-level users: least privilege per app. Prefer pg_hba.conf ...