DB Strike
When your database just start messing around...
Pages
(Move to ...)
Last articles
Kubernetes
Linux articles
Postgres articles
Oracle articles
Glossary
▼
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
‹
›
Home
View web version
No comments:
Post a Comment