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.
