Moreno Andreo <moreno.andreo@xxxxxxxxxx> 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
