Hi
I want to do a backup for a compressed chunk using: COPY (SELECT * FROM _timescaledb_internal.compress_hyper_10_931_chunk) TO ‘/usr/proyectos/test.csv’ WITH (FORMAT CSV, HEADER);
My question is… How can I use that backup to restore it in another DB with the same structure?
In the new DB, the table that contains the compressed chunk doesn’t exists… Compress tables is created when the chunk is compressed
That’s a csv compressed table