When working with data we typically make backups in case we make a mistake. In this age of high speed connections you still want to avoid transferring unnecessary data around, be it because it’s very large or you’re working over a cellphone connection. You can backup the data within the database.
If you only have a single schema available, create a new one for the purpose of backups.
Setting the search_path makes the repl work from the prespective of the new schema.
To copy the table run
Now you can perform your risky operations on the original data with confidence.
If something bad does happen you can restore info by doing