Re: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: lin <jluwln(at)163(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability
Date: 2014-12-01 15:45:20
Message-ID: 547C8D10.40800@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/01/2014 07:35 AM, lin wrote:
> Hi all,
> When using the command "pg_dump -Fd" to backup data, I find the content
> of toc.dat is hard for read, just like this:
> " ^@"^(at)^@^(at)DROP SEQUENCE public.test_id_seq" , So may be we should do
> some work to make the file "toc.dat" more readable.

I believe pg_restore -l is what you are looking for.

http://www.postgresql.org/docs/9.3/interactive/app-pgrestore.html
>
> Thanks,
> Lin
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2014-12-01 15:49:38 Re: Slow delete when many foreign tables are defined
Previous Message Adrian Klaver 2014-12-01 15:42:20 Re: PG94RC1- plv8 functions - problem with input parameter length