Posted over 6 years ago. Visible to the public.

Gerar e restaurar backup de apenas uma tabela Postgres

Gerar backup
pg_dump --host localhost --port 5432 --username "postgres" --format custom --verbose --file "/home/backup_tabela.backup" --table "NOME_SCHEMA.NOME_TABELA" "NOME_BASE"

Restaurar:
pg_restore --host localhost --port 5432 --username "postgres" --dbname "NOME_BASE" --data-only --jobs 4 --table NOME_TABELA --schema public --verbose "/home/backup_tabela.backup"

Owner of this card:

Avatar
João Paulo
Last edit:
over 6 years ago
Posted by João Paulo to ZeroGlosa
This website uses short-lived cookies to improve usability.
Accept or learn more