On 5/23/22 11:29, Tom Lane wrote:
AFAICS, the output produced by -l doesn't mention objects' tablespaces.
You could see them by extracting the plain text archive and grepping
for object comments that include a tablespace name:
pg_restore -s -f - archive_file | grep Tablespace:
It looks to me like that will only appear for tables with non-default
tablespaces.
regards, tom lane
That worked, thank you. I see it has only the "name" so I presume location can be redefined in the receiving cluster.
