Re: pg_restore -l and schema name

Phil Endecott <spam_from_postgresql_general@chezphil.org> writes:
> So this message is really a feature request for "please include the
> schema name in the pg_restore -l output".

Seems reasonable.  I've applied the attached patch to 8.0; you can
probably apply it locally without much trouble (the change is in
PrintTOCSummary() if you can't find the spot easily).

            regards, tom lane


*** src/bin/pg_dump/pg_backup_archiver.c.orig    Fri Sep 10 16:05:18 2004
--- src/bin/pg_dump/pg_backup_archiver.c    Fri Oct  8 10:57:37 2004
***************
*** 699,707 ****
      while (te != AH->toc)
      {
          if (_tocEntryRequired(te, ropt, false) != 0)
!             ahprintf(AH, "%d; %u %u %s %s %s\n", te->dumpId,
                       te->catalogId.tableoid, te->catalogId.oid,
!                      te->desc, te->tag, te->owner);
          te = te->next;
      }

--- 699,708 ----
      while (te != AH->toc)
      {
          if (_tocEntryRequired(te, ropt, false) != 0)
!             ahprintf(AH, "%d; %u %u %s %s %s %s\n", te->dumpId,
                       te->catalogId.tableoid, te->catalogId.oid,
!                      te->desc, te->namespace ? te->namespace : "-",
!                      te->tag, te->owner);
          te = te->next;
      }