X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3E6675E46C3 for ; Fri, 27 Aug 2004 08:15:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62287-01 for ; Fri, 27 Aug 2004 11:15:21 +0000 (GMT) Received: from acheron.rime.com.au (acheron.rhyme.com.au [203.208.66.49]) by svr1.postgresql.org (Postfix) with ESMTP id 8270A5E46CF for ; Fri, 27 Aug 2004 08:15:12 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id ABC0D267407; Fri, 27 Aug 2004 21:15:12 +1000 (EST) Received: from by localhost (amavisd-new, port ) id XXEx0F3w; Fri, 27 Aug 2004 21:15:10 +1000 (EST) Received: by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386), from userid 527) id BF47226740D; Fri, 27 Aug 2004 21:15:10 +1000 (EST) Received: from hephaestus.rhyme.com.au (hephaestus.rime.com.au [203.8.195.122]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 1456B267407; Fri, 27 Aug 2004 21:15:08 +1000 (EST) Message-Id: <6.1.1.1.0.20040827210840.06bd3ad0@203.8.195.10> X-Sender: pjw@203.8.195.10 X-Mailer: QUALCOMM Windows Eudora Version 6.1.1.1 Date: Fri, 27 Aug 2004 21:15:08 +1000 To: Josh Berkus , abief_ag_-postgresql@yahoo.com, Kenneth Gonsalves , pgsql-sql@postgresql.org From: Philip Warner Subject: Re: from PG_DUMP to CVS In-Reply-To: <200408262138.30766.josh@agliodbs.com> References: <20040826120504.58934.qmail@web13925.mail.yahoo.com> <200408262138.30766.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at rhyme.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/300 X-Sequence-Number: 18797 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 some-dbname/econding.sql ... some-dbname/some-schema/TABLE/sometable/create.sql some-dbname/some-schema/TABLE/sometable/drop.sql ... some-dbname/some-schema/CONSTRAINT/someconstraint/create.sql some-dbname/some-schema/CONSTRAINT/someconstraint/create.sql ... some-dbname/some-schema/ACL/some-table.sql some-dbname/some-schema/ACL/some-function(int).sql ... etc. This would be easy. Question is, how useful would it be? ---------------------------------------------------------------- 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 |/