Re: pg_dump options and perhaps 'Enhancement request'

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump options and perhaps 'Enhancement request'
Date: 2003-05-08 21:21:57
Message-ID: 20030508212157.GA5565@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Holle 2003-05-08 21:36:01 Error executing dbcreate
Previous Message Diogo de Oliveira Biazus 2003-05-08 20:49:19 About CLUSTER on GIST/tsearch index