Summary
The pg_dump command can be used to back up a single table, multiple tables, or an entire database. It can output the backup in script or archive file formats.
1
To back up a single table, the pg_dump command can be used with the --table option.
2
Additionally, the pgAdmin tool can be used to back up a single table by selecting the backup option.
3
The pg command can then be used to execute the SQL file in the database.
4
According to
Summary
pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).
Dumps can be output in script or archive file formats.
PostgreSQL: Documentation: 9.1: pg_dump
postgresql.org
Summary
This blog post provides an overview of the two built-in backup utilities, pg_dump and pg_dumpall, for PostgreSQL databases. It explains how to back up a single table, multiple tables, and a database, as well as how to customize the backup and create a script file. It also provides tips on how to use pg_dump to create a script file and how to use pg_dumpall to back up a cluster database.
Backup PostgreSQL Using pg_dump and pg_dumpall | Severalnines
severalnines.com
Summary
This post provides a quick and useful tip on how to dump a PostgreSQL table as insert statements. It explains how to use the pg_dump command to dump the table, and how to use the pg command to execute the SQL file in the database. This tip is useful for quickly and accurately testing the front-end part of an internal tool.
Dump a PostgreSQL table as insert statements
carlosbecker.com
Summary
Using pgAdmin tool: Right-click on a table and select backup option. In Dump Option window, you can find an option like backup Only schema, backup Only Data. Enter your file name path, select backup mode as plain text and take the backup of your table. You can restore this table in any database.
PostgreSQL: How to take a backup of your Table?
dbrnd.com
the directory output format because this is the only output format where multiple processes can write their data at the same time. pg_dump will open njobs + 1 ...
PostgreSQL: Documentation: 15: pg_dump
postgresql.org
the directory output format because this is the only output format where multiple processes can write their data at the same time. pg_dump will open njobs + 1 ...
PostgreSQL: Documentation: 10: pg_dump
postgresql.org
pg_dump is a regular PostgreSQL client application (albeit a particularly clever one). This means that you can perform this backup procedure from any remote ...
PostgreSQL: Documentation: 9.1: SQL Dump
postgresql.org
