Re: from PG_DUMP to CVS

--- Philip Warner <__> wrote:

> At 08:04 PM 26/08/2004, Riccardo G. Facchini wrote:
> >Does somebody know of a script that does this job?
>
> No, but a very useful idea.
>
> Sounds like another dump format to me -- so long as a well-defined
> structure that is likely to remain invariant over versions can be
> used. A
> client uses a trivial script to dump functions, but not tables,
> triggers or
> anything else.
>
> The simplest format might be to use the database names as a level 1
> dir,
> schema names at level 2, and entry names at level 3, then create
> files for
> the 'definition', 'data' etc.
>
> It would be a little confusing when ACLs and constraints were dumped
> (eg.
> they would not appear under the tables). But it would be consistent,
> at least.
>
> Of course it would be impossible to restore from such a beast since
> we
> would be throwing away ordering -- I think.
>
[..]

The plan is not to have something to be restored, but something that
can be published on a CVS server, in order to see what has been
modified overtime... I'd love to have this beast running daily.

If you know of something even similar to what I'm looking for, let me
know.

regards,

Riccardo