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 ready-to-use PostgreSQL cloud solution that provides a host of benefits, including:

• Unlimited connections and data transfers.
• PgAdmin web UI included.
• Many modules included like PostGIS, TimescaleDB and PgVector.
• Effortless updates with just a click.
• Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 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