Restoring to a certain schema

Поиск
Список
Период
Сортировка
От Opis Boi
Тема Restoring to a certain schema
Дата
Msg-id 003101c2d89c$d4765da0$0200a8c0@edpmgr
обсуждение исходный текст
Ответы Re: Restoring to a certain schema
Список pgsql-general
Dear All
 
I have a dump file from v7.2.3 and wanted to restore it to a certain schema in v7.3.2 ( let's call it the abc schema ).
The abc schema is also not the same with my username.
So, if I take a look at the search_path, the $user,public won't take me there.
How do I do that ?
I've take look on the pg_restore options but it seems none of the option provides the solution.
Any idea ? ( except to restore it to the public and copy the tables to the abc schema ? )
 
Thank you in advance
Andy

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