From: Bath, David <dave.bath@unix.net>
To: pgsql-sql@postgresql.org
Subject: Dump/restore comments only?
Date: Mon, 27 Feb 2006 13:56:17 +1100
Message-ID: <200602271356.18537.dave.bath@unix.net> (raw)
Folks,
There have been a number of times when I've wanted to ignore everything
in a dump file apart from comments. I am interested not just in comments
for tables/views/columns but constraints, indices and functions as well.
Many of my comments are multi-line and often resemble manpages, so a
simple grep for '^COMMENT ON' will not work for me.
Has anyone got a script/view in SQL that will generate fully-qualified
COMMENT ON statements from the pg_catalog/information_schema, a
sed|awk|perl script to munge the ascii file produced by pg_dump,
or even pg_dump undocumented options that might help me?
(If there are no such options for dump/restore, might these be useful
inclusions in the future?)
Thanks in advance.
--
David T. Bath
dave.bath@unix.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dave.bath@unix.net
Subject: Re: Dump/restore comments only?
In-Reply-To: <200602271356.18537.dave.bath@unix.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox