> 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