Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group