Skip to content

pgAdmin

pgAdmin 4 is a PostgreSQL administration client. It offers a query tool, a database object browser and maintenance workflows.

Visit pgAdmin

When does a PostgreSQL-specific client fit?

Choose pgAdmin when the database is PostgreSQL and you want its object tree and query tools. It is free under the PostgreSQL licence. You can use a desktop installation or operate a separately hosted server deployment.

A browser login to hosted pgAdmin and a login to the database serve different purposes. Check the database destination and permissions even when you already signed into the client.

Does a CSV give you a database backup?

The Query Tool can save its displayed results as CSV. Use that to keep the rows and columns you selected. A database recovery plan needs an appropriate backup and a verified restore. pgAdmin documents database backups separately.

Use the test database’s restricted reader account for browsing. Choose a storage location you control for an export, since the file does not inherit database access rules.

How can you tell a results file from a backup on paper?

Sketch a fictional PostgreSQL database and an orders table. Use no server, account or actual backup.

  1. Draw the small result
    Write two fictional order rows and choose two columns. Label those cells CSV result.
  2. Name what else a restore needs
    Draw a separate backup box and mark what you would verify on an isolated restore. List table structure and permissions separately from the two rows.