db partial dumping with pg_dump
От | Oleg Bartunov |
---|---|
Тема | db partial dumping with pg_dump |
Дата | |
Msg-id | Pine.GSO.4.44.0208131429270.1769-100000@ra.sai.msu.su обсуждение исходный текст |
Ответы |
Re: db partial dumping with pg_dump
|
Список | pgsql-hackers |
We have a patch for pg_dump which adds a possibility to dump a part of table, for example: dump Top.Science.Astronomy heirarchy from dmoz catalog pg_dump -d -t dmoz -w "select * from dmoz where path <@ 'Top.Science.Astronomy'" dmoz We found it's very useful. We'd like to extend it to use also with COPY but it has no support for select (of course it will works only for special case when ALL columns retrieved). The question is: Is't worth to submit patch for pg_dump and look into copy code ? Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления: