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

Started by LitelWangover 22 years ago2 messagesgeneral
Jump to latest
#1LitelWang
wlxyk@vip.163.com

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 .

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: LitelWang (#1)
Re: why can't I find the other schemas in my restored database except public schemas ?

"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