Re: [SQL] from PG_DUMP to CVS

2004-08-28 Thread Philip Warner
At 02:02 AM 28/08/2004, Josh Berkus wrote: some-dbname/some-schema/TABLES/sometable.sql some-dbname/some-schema/VIEWS/someview.sql some-dbname/some-schema/FUNCTIONS/somefunction-param{codes}.sql some-dbname/some-schema/TYPES/sometype.sql some-dbname/some-schema/OPERATORS/OPsomeoperator.sql In this

Re: [SQL] from PG_DUMP to CVS

2004-08-27 Thread Josh Berkus
Philip, > My thinking at this stage is to try to get pg_dump/restore to produce the > output directly. Something like: Hey, you do what you want, of course. However, it seems to me that hacking AutoDoc would be a *lot* less effort than hacking pg_dump. Interestingly, though, I was talking t

Re: [SQL] from PG_DUMP to CVS

2004-08-27 Thread Riccardo G. Facchini
That depends on the use you plan to... as a backup, useless, as a documentary tool, very (at least, for what I need). Our way of developing things is to set up a development box, and set up the tables, functions, etc etc etc using a set of tools... the only problem is that these do not provide an

Re: [SQL] from PG_DUMP to CVS

2004-08-27 Thread Philip Warner
At 02:38 PM 27/08/2004, Josh Berkus wrote: If it's Perl, I'd be interested in contributing. I've long needed something like this myself. My thinking at this stage is to try to get pg_dump/restore to produce the output directly. Something like: some-dbname/create.sql some-dbname/drop.sql

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Josh Berkus
Riccardo, > Looks promising, but still what I need is a proper CVS output, as I > need to review the changes made to the specific database structure. If it's Perl, I'd be interested in contributing. I've long needed something like this myself. -- Josh Berkus Aglio Database Solutions San Fran

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Greg Stark
"Riccardo G. Facchini" <[EMAIL PROTECTED]> writes: > After searching throught the list, I assume you mean this link: > http://www.rbt.ca/autodoc/index.html > by Rod Taylor. > > Looks promising, but still what I need is a proper CVS output, as I > need to review the changes made to the specific da

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Riccardo G. Facchini
--- Kenneth Gonsalves <__> wrote: > On Thursday 26 August 2004 04:48 pm, Philip Warner wrote: > > At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote: > > >If you know of something even similar to what I'm looking for, let > me > > >know. > > > > My thinking is to modify pg_dump to add a new outpu

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Riccardo G. Facchini
--- Philip Warner <__> wrote: > At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote: > >If you know of something even similar to what I'm looking for, let > me > >know. > > My thinking is to modify pg_dump to add a new output format, but I'd > like > to get some more feedback from others first,

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Kenneth Gonsalves
On Thursday 26 August 2004 04:48 pm, Philip Warner wrote: > At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote: > >If you know of something even similar to what I'm looking for, let me > >know. > > My thinking is to modify pg_dump to add a new output format, but I'd like > to get some more feedback

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Philip Warner
At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote: If you know of something even similar to what I'm looking for, let me know. My thinking is to modify pg_dump to add a new output format, but I'd like to get some more feedback from others first, including yourself. Does what I specified before s

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Riccardo G. Facchini
--- 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 v

Re: [SQL] from PG_DUMP to CVS

2004-08-26 Thread Philip Warner
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 scr

[SQL] from PG_DUMP to CVS

2004-08-26 Thread Riccardo G. Facchini
Hi All, Does somebody know of a script that is capable of creating a CVS tree based on the structure of a given schema or database? I have a development DB that is structured with a lot of tables, functions, views, indexes... I've been asked to publish all the changes under a CVS tree, separating