Re: Removing Comments in pg_dump

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: aspire420(at)hotpop(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Removing Comments in pg_dump
Date: 2004-03-12 03:18:37
Message-ID: 200403120318.i2C3Ibv18685@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


They will not appear in 7.5. The only fix until then is to use sed to
remove it.

---------------------------------------------------------------------------

V i s h a l Kashyap @ [Sai Hertz And Control Systems] wrote:
> Dear all,
>
> Normally when a pg_dump is done on a database schema it inserts some
> comments as follows
>
> <code>
> --
> -- Definition for function my_func_ay (OID = 4446535) :
> --
> </code>
>
> How can these type of comments be avoided or not included in the dump file.
>
> Using:
> PostgreSQL 7.3.4
>
>
>
>
>
>
> --
> Best Regards,
> Vishal Kashyap
> Director / Lead Developer,
> Sai Hertz And Control Systems Pvt Ltd,
> http://saihertz.rediffblogs.com
> Jabber IM: vishalkashyap(at)jabber(dot)org
> ICQ : 264360076
> Yahoo IM: mailforvishal(at)yahoo(dot)com
> -----------------------------------------------
> You yourself, as much as anybody in the entire
> universe, deserve your love and affection.
> - Buddha
> ---------------
> pgsql=# select marital_status from vishals_life;
>
> marital_status
> ------------------
> Single not looking
>
> 1 Row(s) affected
>
> ___
> //\\\
> ( 0_0 )
> ----------------o0o-----o0o---------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jacques Capesius 2004-03-12 04:14:46 PHP/PGSQL error after rebooting
Previous Message stm23 2004-03-12 03:07:30 setting up postgresql