Moreno Andreo <moreno.andreo@evolu-s.it> writes:
> I have an issue with a Windows 10 PC with Postgres 9.1 x86.
You realize 9.1 is long out of support ...
> Running some SELECTs we got "ERROR: could not open file
> "base/48121/784576": No such file or directory"
Ugh :-(
> Now I need to recreate an empty copy of this table (data can be
> recovered later), how can I achieve this?
TRUNCATE ought to be enough.
regards, tom lane