PostgreSQL: Exporting data from PostgreSQL to your computer

This documentation is part of the Getting started guide. You can view the complete guide here: How to get started with PostgreSQL.

👋 Welcome to the Stackhero documentation!

Stackhero offers a fully managed PostgreSQL cloud solution, designed for reliability and performance:

• Unlimited connections and data transfers for effortless scalability.
• PgAdmin web interface included for straightforward database management.
• A wide range of popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
• Simple, one-click updates to keep your database secure and up to date.
• Optimal performance and enhanced security on private, dedicated infrastructure.

Save time and make your life easier: it takes just 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!

Exporting data from your PostgreSQL instance to your computer is just as straightforward using the PostgreSQL CLI.

1. To export the entire database (replace <DB_NAME> with your database name):

   pg_dump \
     --host=<XXXXXX>.stackhero-network.com \
     --username=admin \
     --port=<PORT> \
     --dbname=<DB_NAME> \
     > data.pgsql
   

2. To export a single table (replace <DB_NAME> with your database name and <TABLE_NAME> with your table name):

   pg_dump \
     --host=<XXXXXX>.stackhero-network.com \
     --username=admin \
     --port=<PORT> \
     --dbname=<DB_NAME> \
     --table=<TABLE_NAME> \
     > data.pgsql