Re: A little pg_dump patch

Ok, but with this hack I need 2 databases, one with comments and
another without comments.
I prefer to have only one db with comments and choice to have a dump
with comments or without comments.

regards,
Enrico

2011/9/19 Greg Sabino Mullane <greg(at)turnstep(dot)com>:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
>>> I wrote this little patch, becuse  my customer doesn't want to have
>>> comments on the production db. It's not my choice
>>
>> Then use pg_restore --use-list to filter them out, and you won't need a
>
> Or just strip them out after the fact with a little bit of SQL, e.g.
>
> DELETE FROM pg_description WHERE objoid > 50000;
>
> (test first, your system may vary and 50000 may not work)
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)com
> End Point Corporation http://www.endpoint.com/
> PGP Key: 0x14964AC8 201109191143
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iEYEAREDAAYFAk53YzsACgkQvJuQZxSWSsgA0wCguiURJI4Hneu7Dn+vBtcEOLsR
> /OcAn35ujJCWhf2tM3a1J2yek0uddF1X
> =wc3x
> -----END PGP SIGNATURE-----
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

--
That's one small step for man; one giant leap for mankind