Forrest logo
back to the pg_dump tool

pg_dump:tldr:f6d1d

pg_dump: Dump only schema (data definitions) into an SQL-script file.
$ pg_dump -s ${db_name} > ${path-to-output_file-sql}
try on your machine

This command is using the pg_dump tool to create a SQL dump file of a PostgreSQL database schema. Here is the breakdown of the command:

  • pg_dump is a PostgreSQL utility used for creating backups or exporting database objects.
  • -s flag specifies that only the schema of the database should be dumped, excluding the data.
  • ${db_name} is the placeholder for the name of the database you want to dump.
  • > ${path-to-output_file-sql} redirects the output of the pg_dump command to a specified file. ${path-to-output_file-sql} is the placeholder for the desired file path where the SQL dump will be saved.

When running this command, you need to replace ${db_name} with the actual name of your database and ${path-to-output_file-sql} with the path and name of the file where you want to save the SQL dump.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.
back to the pg_dump tool