Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 87CC59FB67A for ; Tue, 3 Jul 2007 20:37:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 56349-09 for ; Tue, 3 Jul 2007 20:37:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.224]) by postgresql.org (Postfix) with ESMTP id 8237D9FB440 for ; Tue, 3 Jul 2007 20:37:40 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h29so1500801wxd for ; Tue, 03 Jul 2007 16:37:39 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=N4UVzQJpEry3iId8JbJtEW3ce5ErbavBDeuoK/u3ybyyDbthX6gpRzZUxcXb/bcWctOKkGvmcAntl0rwIOp9jBWy16I6xMVAwiPeXdfYbXbSGg/g4PU6JL/yDwLVsQJw2UZW6vg2k/I4R8a5z9hnYaRK5F/SaBFyeun7zGJWjmg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=cx8oCj96hD+SQugjlSM9nIke8rn1E4GUtxntn0N7IAzxFZDB3yKWAfJU2N/7p68LKJZnShxEDhB9q8sRamiVS+UmNSkO15zvXvB+HgirFS5f5F+RY78tYMdLIYgLDU6QJdX6SIQpqUf4Zu0gN5yZU7s8LOJRGnMpJeaN6pd5c/s= Received: by 10.90.33.16 with SMTP id g16mr6805978agg.1183505859469; Tue, 03 Jul 2007 16:37:39 -0700 (PDT) Received: from ?192.168.3.170? ( [68.79.189.145]) by mx.google.com with ESMTP id 8sm12016324agd.2007.07.03.16.37.38 (version=SSLv3 cipher=RC4-MD5); Tue, 03 Jul 2007 16:37:38 -0700 (PDT) Subject: Re: Informix Schema -> PostgreSQL ? From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-sql@postgresql.org In-Reply-To: <468A8C08.1060803@g2switchworks.com> References: <468A77B6.2070706@noaa.gov> <468A8C08.1060803@g2switchworks.com> Content-Type: text/plain Date: Tue, 03 Jul 2007 19:35:43 -0400 Message-Id: <1183505743.4127.3.camel@aleph.whitemice.org> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/26 X-Sequence-Number: 28761 > pg_dump dbname -s -t tableorindexname [Also an Informix DBA] Is there a way to tweak the output of pg_dump when used in this manner to omit the verbose commentary. $ pg_dump OGo -s -t enterprise .... -- -- Name: unique_enterprise_login; Type: INDEX; Schema: public; Owner: OGo; Tablespace: -- CREATE UNIQUE INDEX unique_enterprise_login ON enterprise USING btree ("login"); The "--" lines just eats up screen real estate. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org