Re: Dump/restore with bad data and large objects
От | Joshua Drake |
---|---|
Тема | Re: Dump/restore with bad data and large objects |
Дата | |
Msg-id | 20080825104711.2ddfafd9@jd-laptop обсуждение исходный текст |
Ответ на | Re: Dump/restore with bad data and large objects ("John T. Dow" <john@johntdow.com>) |
Ответы |
Re: Dump/restore with bad data and large objects
|
Список | pgsql-general |
On Mon, 25 Aug 2008 13:37:13 -0400 "John T. Dow" <john@johntdow.com> wrote: > Joshua > > The TOC feature sounds good, as does converting a single table to > plain text. > > But I can't find documentation for the TOC feature under pg_dump or > pg_restore. I'm looking in postgresql-8.2.1-US.pdf. The commands you are looking for are: pg_restore -l to get the toc pg_restore -L to use the toc If you open the resulting file from something like pg_restore -l > foo.toc it is just a plain text list of objects to restore. I don't know how well it is documented but I am sure we would accept a patch. > > Neither could I see anything about converting a single table to a > plain text dump. pg_restore allows you to do so. Something like: pg_restore foo.sqlc --file=foo.sql > > Also, I stumbled across the statement that you can't restore large > objects for a single table. Is that true? Large objects are stored in a central table called pg_largeobject, so yes that would be accuarate. > > Another thing I couldn't find was how to dump roles using -Fc. > You can't; that is a known and irritating limitation. Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-general по дате отправления: