Hi Tom and thanks for your time,
Il 05/09/19 15:53, Tom Lane ha scritto:
> Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)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 ...
Absolutely :-)
I'm about to migrate it to 11
> 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.
truncate pg_toast_49713;
ERROR: relation "pg_toast_49713" does not exist
:-\
... or do I need to truncate the "master" table (the table blobs are in)?
Thanks