How to browse, query and export a PostgreSQL database

For hosting customers · Updated 2026-10-29

On this page
  1. Open the tool
  2. Browse tables
  3. Run SQL
  4. Export the database
  5. Import a .sql file
  6. Common questions

Each PostgreSQL database has a built-in tool in the control panel to look at tables, run SQL and make an export.

Open the tool

  1. Log in to the control panel (https://<server>:2083).
  2. Open PostgreSQL Databases (section Databases).
  3. Click Open next to the database.

Browse tables

The Tables list on the left shows every table with its size. Click a table to see its rows, 100 at a time; use Previous and Next to page through.

Run SQL

  1. Type a statement in the SQL box, for example:
    SELECT * FROM orders ORDER BY id DESC LIMIT 20;
  2. Click Run.

A query shows its rows (at most 500). A change such as UPDATE shows Done. and the number of row(s) changed. If the statement is wrong, the error from PostgreSQL is shown.

Limits: statements run on this database only and are stopped after 15 seconds.

Export the database

  1. Click Export (SQL) at the top right.
  2. You see Exporting to postgres-exports/username_app-YYYYMMDD-HHMMSS.sql in your home folder (File Manager). Big databases take a minute.
  3. Open the File Manager, go to the postgres-exports folder and download the file.

Delete old exports when you no longer need them; they count toward your disk space.

Import a .sql file

The tool has no import. If your plan has shell access, upload the file with SFTP and run in Terminal:

psql -h localhost -U username_app username_app < ~/dump.sql

For short scripts, you can also paste the statements into the SQL box.

Common questions

My query was stopped. What can I do?

Statements are stopped after 15 seconds. Add a LIMIT, an index, or run long jobs with psql over SSH.

Why do I see only 500 rows?

The tool shows at most 500 rows per query. Use LIMIT and OFFSET, or export the data.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.