From: Bath, David <dave.bath@unix.net>
To: pgsql-sql@postgresql.org
Subject: selective dump pg_dump: only specific non-tables? with schema name?
Date: Mon, 14 Nov 2005 13:08:06 +1100
Message-ID: <200511141308.07582.dave.bath@unix.net> (raw)
Hi folks,
Three questions about pg_dump (that might be a feature request). Let me
know if pg_dump is not the best tool for this sort of thing.
1. Can I pg_dump only non-table information from the command line
e.g. single function, all functions, trigger definitions?
2. Can I pg_dump schema objects that include the schema prefix "inline"
e.g. CREATE FUNCTION "fred"."func1"
3. Can I pg_dump "CREATE OR REPLACE" rather than straight "CREATE",
especially for functions?
--
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: selective dump pg_dump: only specific non-tables? with schema name?
In-Reply-To: <200511141308.07582.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