How to browse, query and export a PostgreSQL database
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
- Log in to the control panel (
https://<server>:2083). - Open PostgreSQL Databases (section Databases).
- 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
- Type a statement in the SQL box, for example:
SELECT * FROM orders ORDER BY id DESC LIMIT 20; - 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
- Click Export (SQL) at the top right.
- You see Exporting to postgres-exports/username_app-YYYYMMDD-HHMMSS.sql in your home folder (File Manager). Big databases take a minute.
- Open the File Manager, go to the
postgres-exportsfolder 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.
Thank you — this helps us improve the article.
Still stuck?
Ask the AI about your exact situation — it answers from this knowledge base — or contact us.
Related articles
- How to create a PostgreSQL database and user
Create a PostgreSQL database and user in the control panel, add the user to the database, and connect your app with host localhost and port 5432.
- How to export a MySQL database (download a .sql backup)
Download a copy of a MySQL database as a .sql file with phpMyAdmin's Export tab or mysqldump over SSH, for backups or moving to another server.
- How to import a MySQL database (.sql file) and size limits
Import a .sql or compressed .sql.gz backup into a MySQL database with phpMyAdmin (up to 512 MB) or the mysql command over SSH for larger files.