Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 56F546342BF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Mar 2009 12:22:27 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 54852-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Mar 2009 12:22:26 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by mail.postgresql.org (Postfix) with ESMTP id ABB24633056
	for <pgsql-admin@postgresql.org>; Thu, 26 Mar 2009 12:22:24 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.3/8.14.3) with ESMTP id n2QFMN2X015896
	for <pgsql-admin@postgresql.org>; Thu, 26 Mar 2009 12:22:23 -0300 (ADT)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.3/8.14.3/Submit) id n2QEsaed004069
	for pgsql-admin@postgresql.org; Thu, 26 Mar 2009 11:54:36 -0300 (ADT)
	(envelope-from news)
From: "Sabin Coanda" <sabin.coanda@deuromedia.ro>
X-Newsgroups: pgsql.admin
Subject: plain text difference with pg_dump
Date: Thu, 26 Mar 2009 16:53:55 +0200
Organization: Hub.Org Networking Services
Lines: 18
Message-ID: <gqg4vc$3ut$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
To: pgsql-admin@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/231
X-Sequence-Number: 31731

Hi there,

I have two databases DD and DP. DD is used for development, and DP in 
production.
After develop something on DD, a diff package is made and it upgrades DP. 
Normally after that DD has to be identically with DP.

The problem is when I check the structure difference between DD and DP. My 
procedure is to use pg_dump to make a plain text dump of the two databases, 
and compare them, ignoring the comments. All the procedures are sorted 
identically, excepting those with the same name, but different arguments.

Do you know a method to get the same text dump ?

TIA,
Sabin