Обсуждение: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability

Поиск
Список
Период
Сортировка
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.

Thanks,
Lin



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

От
Adrian Klaver
Дата:
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