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

SchemaCrawler for PostgreSQL

From: <sualeh(at)hotmail(dot)com>
To: <pgsql-announce(at)postgresql(dot)org>
Subject: SchemaCrawler for PostgreSQL
Date: 2007-08-08 12:22:26
Message-ID: BAY120-DS1C0C0165C2F14AF83D3DCC9E70@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
I wanted to announce SchemaCrawler for PostgreSQL, a command-line tool to output your database schema and data in a readable form. 

SchemaCrawler is free, open-source, operating system independent, command-line tool that can take human-readable snapshots of the schema and data, for later comparison. Comparisons are done using a standard diff tool. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. 

SchemaCrawler Grep is another tool that comes with the SchemaCrawler download. SchemaCrawler Grep that allows you to search for certain column names within the database schema. 

I have bundled SchemaCrawler (and SchemaCrawler Grep) for PostgreSQL into a pre-packaged download, and it includes everything that you need to work with PostgreSQL. 

SchemaCrawler for PostgreSQL is available at SourceForge:

The SchemaCrawler website is

Sualeh Fatehi.

pgsql-announce by date

Next:From: David FetterDate: 2007-08-13 04:50:11
Subject: == PostgreSQL Weekly News - August 12 2007 ==
Previous:From: Dave PageDate: 2007-08-07 21:55:08
Subject: EnterpriseDB Announces First-Ever Professional-Grade PostgreSQL Distribution for Linux

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