PostgreSQL备份和恢复数据表
备份数据表:
pg_dump -U user_name db_name -t table_name -f /tmp/backup_file.suffix
恢复数据表:
方法1: 登录数据库:\i /tmp/backup_file.suffix
方法2: psql -U user_name db_name -f ./Documents/backup_test.sql
--- --- LilyLee --- ---
备份数据表:
pg_dump -U user_name db_name -t table_name -f /tmp/backup_file.suffix
恢复数据表:
方法1: 登录数据库:\i /tmp/backup_file.suffix
方法2: psql -U user_name db_name -f ./Documents/backup_test.sql