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

Started by linover 11 years ago2 messagesgeneral
Jump to latest
#1lin
jluwln@163.com

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

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: lin (#1)
Re: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general