losing schema name in pg_dump

Поиск
Список
Период
Сортировка
От c k
Тема losing schema name in pg_dump
Дата
Msg-id CAN2Y=uOekJyn8i4rONN0SOCTZhFFJ0i+VLkkNFyEKGQYVKZEsA@mail.gmail.com
обсуждение исходный текст
Ответы Re: losing schema name in pg_dump  (c k <shreeseva.learning@gmail.com>)
Список pgsql-general
Hi all,

Many times I have to dump all objects from a schema (single schema holding only functions and views) in plain text format. It is found that pg_dump includes a set search_path statement at the beginning and drops all occurrences of the schema name (to which dumped object belongs) from function/view bodies even if they are explicitly defined while creating functions/views.

Functions or view definition from information_schema tables shows the explicitly defined schema names but pg_dump does not shows them. Is there any switch to change this behaviour? Or pg_dump has this by default and we can not change this?
This makes it problematic to maintain the software available for another RDBMS as for most other RDBMS we have to explicitly define schema names always.

Thanks,

C P Kulkarni


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

Предыдущее
От: c k
Дата:
Сообщение: Re: suggestion for backup (pg_dump)
Следующее
От: John Townsend
Дата:
Сообщение: Re: Libpq question