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

From Adrian Klaver
Subject Re: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability
Date
Msg-id 547C8D10.40800@aklaver.com
Whole thread Raw
In response to The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability  (lin <jluwln@163.com>)
List 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:
> " ^@"^@^@^@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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PG94RC1- plv8 functions - problem with input parameter length
Next
From: Andy Colson
Date:
Subject: Re: Slow delete when many foreign tables are defined