Postgres Pro
Downloads
Home   >   mailing lists

Re: Informix Schema -> PostgreSQL ? - Mailing list pgsql-sql

From Adam Tauno Williams
Subject Re: Informix Schema -> PostgreSQL ?
Date
Msg-id 1183505743.4127.3.camel@aleph.whitemice.org
Whole thread Raw
In response to Re: Informix Schema -> PostgreSQL ?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Informix Schema -> PostgreSQL ?  ("Jaime Casanova" <systemguards@gmail.com>)
Re: Informix Schema -> PostgreSQL ?  (Nis Jørgensen <nis@superlativ.dk>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Iterate and write a previous row to a temp table?
Next
From: "Jaime Casanova"
Date:
Subject: Re: Informix Schema -> PostgreSQL ?