Re: from PG_DUMP to CVS

--- 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, including yourself. Does
> what 
> I specified before satisfy all your needs?
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 03 5330 3172          |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                   |    --________--
> PGP key available upon request,  |  /
> and from pgp.mit.edu:11371       |/ 
> 
> 

yes, I think a specific format for pg_dump could be interesting.
From my point of view, I would like to get a directory structure like
this one:

<database name>/schemas /<schema name>  /<schema name>.sql  /tables   /<table name>.sql  /views   /<view name>.sql
/functions  /<function name>.sql  /domains   /<domain name>.sql  /types   /<type name>.sql  /aggregates   /<aggregate
name>.sql /operators   /<operator name>.sql  /priming   /<table name>.sql  /acls   /schemas    /<schema name>
/<schemaname>.sql     /tables      /<table name>.sql     /views      /<view name>.sql     /functions      /<function
name>.sql    /domains      /<domain name>.sql     /types      /<type name>.sql     /aggregates      /<aggregate
name>.sql    /operators      /<operator name>.sql/languages /<language name>.sql 
 
either following the pgadmin3 style or, better still, the ems
postgresql manager output style (I believe is superior, even if not
OS).

My feeling is that a lot of the code for an output of this kind is
already in the pgadmi3 code, so it could be a matter of codebashing.

I wouldn't separate the functions from the triggers, but beware of the
function overloading, but that's a small issue compared to the task. 

best regards,



=====
Riccardo G. Facchini