From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_restore -l and schema name |
Date: | 2004-10-08 15:05:16 |
Message-ID: | 12667.1097247916@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)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;
}
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Klassen | 2004-10-08 15:17:07 | Re: CGI program cannot access database |
Previous Message | Michael Glaesemann | 2004-10-08 14:37:06 | Re: when to use NULL and when to NOT NULL DEFAULT '' |