Re: list tablespaces named in custom format dump

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 5/23/22 9:54 AM, Rob Sargent wrote:
>> Roger that, but does the dump of a database name the tablespaces from 
>> which the objects were retrieved? And if so, is that accessible?

> Would indicate it does. I don't have cluster set up with tablespaces to 
> test, but I would try:
> pg_restore -l <custom_format_file>

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