Copying tables as a backup
I understand there's a means to backup a table via vbr.py, but as far as I understand this script can be invoked only by the dbadmin.
We're looking at backing up our tables by creating a backup table using the CREATE TABLE statement along with the LIKE clause and then performing a COPY. In this case, will all the data be copied over to the new table, or under the hood will there be only a rearrangement of pointers? We're trying to evaluate the space requirements associated with performing a full COPY of the table.