From: | "Bath, David" <dave(dot)bath(at)unix(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Dump/restore comments only? |
Date: | 2006-02-27 02:56:17 |
Message-ID: | 200602271356.18537.dave.bath@unix.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)bath(at)unix(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2006-02-27 07:19:30 | Problem with query on history table |
Previous Message | Bath, David | 2006-02-27 02:44:31 | Disabling triggers/constraints pg<8.1 |