selective dump pg_dump: only specific non-tables? with schema name?

Поиск
Список
Период
Сортировка
От Bath, David
Тема selective dump pg_dump: only specific non-tables? with schema name?
Дата
Msg-id 200511141308.07582.dave.bath@unix.net
обсуждение исходный текст
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Christian Paul B. Cosinas"
Дата:
Сообщение: Re: Problem with "NOT IN (subquery)
Следующее
От: "Dinesh Pandey"
Дата:
Сообщение: Connection Oracle database from Postgres function