SyntaxFix

[postgresql] How to create a backup of a single table in a postgres database?

If you are on Ubuntu,

  1. Login to your postgres user sudo su postgres
  2. pg_dump -d <database_name> -t <table_name> > file.sql

Make sure that you are executing the command where the postgres user have write permissions (Example: /tmp)

Edit

If you want to dump the .sql in another computer, you may need to consider skipping the owner information getting saved into the .sql file.

You can use pg_dump --no-owner -d <database_name> -t <table_name> > file.sql

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to backup

• input file appears to be a text format dump. Please use psql • How can I backup a Docker-container with its data-volumes? • Backup/Restore a dockerized PostgreSQL database • Export MySQL database using PHP only • Tar a directory, but don't store full absolute paths in the archive • How to extract or unpack an .ab file (Android Backup file) • mysqldump with create database line • Postgresql 9.2 pg_dump version mismatch • How to backup Sql Database Programmatically in C# • Opening a SQL Server .bak file (Not restoring!)

Examples related to pg-dump

• Postgresql 9.2 pg_dump version mismatch • How to create a backup of a single table in a postgres database?