DB Strike
When your database just start messing around...
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment