Search This Blog

Friday, July 21, 2017

Postgres SQL: pg_dump / pg_restore

Backup a specific table:
pg_dump --table TABLENAME -U postgres dbName -f /home/postgres/TABLENAME.sql


If there is a table with the same name in another schema, use the --schema SCHEMANAME option

No comments:

Post a Comment