Hands-on task
PostgreSQL: dump and restore
In the shop database there is a customers table with data. Dump only this table to /root/customers.sql, create a new database shop_copy, and restore the table into it so that all rows are in place.
- pg_dump
- createdb
- psql
- backup/restore
- input redirection