Skip site navigation (1) Skip section navigation (2)

Re: from PG_DUMP to CVS

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Josh Berkus <josh(at)agliodbs(dot)com>, abief_ag_-postgresql(at)yahoo(dot)com,Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: from PG_DUMP to CVS
Date: 2004-08-28 16:10:26
Message-ID: 6.1.1.1.0.20040829020436.04705d30@203.8.195.10 (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-sql
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 last, all dependant objects of, for example, a table (rules, 
>triggers,
>indexes, etc. ) would be rolled up into one file.  It's this last version
>that I personally favor.

Not sure I like it from the PoV of easily seeing what has changed.

Similarly:

>some-dbname/some-schema/TABLES/sometable/create.sql
>some-dbname/some-schema/TABLES/sometable/indexes.sql
>some-dbname/some-schema/TABLES/sometable/constraints.sql

combines all indexes into one file. It also has the disadvantage if being 
impossible to construct from an existing dump file.

I'd like to be able to construct the structure from the information stored 
in a dump file, without parsing SQL. OTOH, it might be nice to add some 
more information to the dump file.



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


In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-08-28 16:19:37
Subject: Re: Aggregate query for multiple records
Previous:From: Gaetano MendolaDate: 2004-08-28 12:48:40
Subject: Re: backup of a specific schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group