Обсуждение: why can't I find the other schemas in my restored database except public schemas ?

Поиск
Список
Период
Сортировка

why can't I find the other schemas in my restored database except public schemas ?

От
"Litel Wang"
Дата:
I create a database in the server of my company and get a backup of this database .
but I can't find the other schemas (such as pg_catlog,pg_toast) in my restored
database except public schemas when I restore it at home .what's the problem ?
Thanks for any advice .



Re: why can't I find the other schemas in my restored database except public schemas ?

От
Tom Lane
Дата:
"Litel Wang" <wlxyk@vip.163.com> writes:
> I create a database in the server of my company and get a backup of this database .
> but I can't find the other schemas (such as pg_catlog,pg_toast) in my restored
> database except public schemas when I restore it at home .what's the problem ?

What do you mean by "you can't find them", exactly?  Those two schemas
are there in any 7.3 database --- I don't believe it's possible to
remove them ...

            regards, tom lane