Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yq0VN-0005lH-1z for pgsql-general@arkaria.postgresql.org; Wed, 06 May 2015 14:40:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yq0VM-0000nl-Gh for pgsql-general@arkaria.postgresql.org; Wed, 06 May 2015 14:40:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yq0VL-0000lg-0A for pgsql-general@postgresql.org; Wed, 06 May 2015 14:40:55 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Yq0VI-0003jL-6r for pgsql-general@postgresql.org; Wed, 06 May 2015 14:40:53 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 1B21420F3E for ; Wed, 6 May 2015 10:40:50 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute1.internal (MEProxy); Wed, 06 May 2015 10:40:50 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h=cc :content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=U6Y2sJxFWpTsVorEjAWB37dSbwk=; b=LIXe1n veyW3D0O+3zMeMisKsQINf1iqwTPH92ugwlU4uyXl7PvlYKnLSFvGS0+3TGLpFOR Aj2tbmtU5dn7IOX8L1CQbspDlANVJA/WHtEI0Tn5gHYQMBaYfe37v33kdjwKKLHY qzneYl/eudt+zTofMbE0EFxRCp/OeDy5R3rV4= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=U6Y2sJxFWpTsVor EjAWB37dSbwk=; b=NbXlutKyMhcdlsD7DPFJVFPKtre4SLxXnA4Ggow5u35a+4s cwYNvrKl1W9JauQdWZyF79zi2hBRaZXMIEqk2mrzDVSFJugQ5YmBJkHK1WeycaVi jj5Douxuxq0lJxFzjZM9+lCnQ9LlMY3SjtLJEAvHGMYCI+opzmduKgBVBGjU= X-Sasl-enc: DxWZ71F6IDeboCAcjwRQCItHNmadTE238k7NQ/nmkYOP 1430923249 Received: from [192.168.1.2] (unknown [174.21.228.230]) by mail.messagingengine.com (Postfix) with ESMTPA id 2B8C36800FA; Wed, 6 May 2015 10:40:48 -0400 (EDT) Message-ID: <554A27F0.7010602@aklaver.com> Date: Wed, 06 May 2015 07:40:48 -0700 From: Adrian Klaver User-Agent: Mozilla/5.0 (X11; Linux i686; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: Suresh Raja , Melvin Davidson CC: "Joshua D. Drake" , "pgsql-general@postgresql.org" , pgsql-sql@postgresql.org Subject: Re: [SQL] documenting tables version control References: <554927D0.9060900@commandprompt.com> In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 05/06/2015 07:31 AM, Suresh Raja wrote: > Thanks Melvin, Joshua, PT and Steve! > > your information is good. Im looking for creating a catalog for my > application schema. Do you have anything that you use for catalog of > your schema. Maybe using excel. Yes Mercurial(mercurial.selenic.com) with Sqitch(sqitch.org). Then you get a current catalog and a history of your catalog changes in Mercurial and a way to go backwards and forwards in deploying those changes using Sqitch. > > Thanks, > SR -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general