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.
