Re: pg_dump options and perhaps 'Enhancement request' - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: pg_dump options and perhaps 'Enhancement request'
Date
Msg-id 20030508212157.GA5565@libertyrms.info
Whole thread Raw
In response to pg_dump options and perhaps 'Enhancement request'  (Terry Yapt <pgsql@technovell.com>)
List pgsql-general
On Thu, May 08, 2003 at 10:11:48PM +0200, Terry Yapt wrote:
> 1-) Are there any way to do a pg_dump without '--' COMMENTS ?  For
> example, I don't like to have this in my output file:
> --
> -- TOC entry 19 (OID 26027)
> -- Name: TABLE news; Type: COMMENT; Schema: www; Owner: www
> --

You could do this with grep (and something similar for blank lines):

pg_dump [options] dbname | grep -v "^--" > dumpfile

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Diogo de Oliveira Biazus
Date:
Subject: About CLUSTER on GIST/tsearch index
Next
From: Jeff Holle
Date:
Subject: Error executing dbcreate