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 <g...@turnstep.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 g...@turnstep.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@postgresql.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers