Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2F3AE2E01EB for ; Tue, 4 Mar 2008 16:58:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90080-01-6 for ; Tue, 4 Mar 2008 16:58:43 -0400 (AST) X-Greylist: delayed 00:11:24.2081 by SQLgrey-1.7.5 Received: from perseverance.services.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by postgresql.org (Postfix) with ESMTP id C093B2E2DBA for ; Tue, 4 Mar 2008 16:58:46 -0400 (AST) Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca [132.205.47.225]) by perseverance.services.encs.concordia.ca (envelope-from emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id m24KlEua016670; Tue, 4 Mar 2008 15:47:14 -0500 Message-ID: <47CDB551.5010400@encs.concordia.ca> Date: Tue, 04 Mar 2008 15:47:13 -0500 From: Emi Lu Reply-To: emilu@encs.concordia.ca User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Shahaf Abileah CC: pgsql-sql@postgresql.org Subject: Re: Documenting a DB schema References: <082D8A131DF72A4D88C908A1AD3DEB22023B34F2@mail-1.rf.lan> In-Reply-To: <082D8A131DF72A4D88C908A1AD3DEB22023B34F2@mail-1.rf.lan> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.58 on perseverance.encs.concordia.ca at 2008/03/04 15:47:14 EST X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/11 X-Sequence-Number: 30339 Hi, > I'm looking for a systematic way to document the schema for the database > behind our website (www.redfin.com ), so that > the developers using this database have a better idea what all the > tables and columns mean and what data to expect. Any recommendations? I am using Case Studio to document DB structures. I think it is pretty good tool. http://www.casestudio.com/enu/default.aspx To browse DB objects only, try DbVisualizer: http://www.minq.se/products/dbvis/ - Ly