Re: 7.2 stuff

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   |/