At 23:21 26/11/01 -0500, Tom Lane wrote:
>
>> For instance, I would like to be able to pg_dump all the diary tables in
one
>> go.
>> ie. pg_dump -t diary_\* audb > dump.sql
>> Don't know if there would be widespread enough demand for this feature
>> tho...
>
>I've seen requests for that before ... and I don't think they were all
>from you ;-). Seems like a reasonable wishlist item to me.
>
I have been sent patches for this kind of thing, but I would like to see
them generalized to some extent. Not sure of the syntax, but I'd like to be
able to dump *any* selected pg_dump TOC entry type by name, or partial name
match. ie. tables, functions, indexes, etc.
Any suggestions as to how this is best done within unix-like commands? eg.
pg_dump/restore --select=table:<regexp> ? pg_dump/restore --select=index:<regexp> ?
Any ideas?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/