Re: why can't I find the other schemas in my restored d

pg_catalog & pg_toast are not directly dumped with backups.
pg_catalog is system maintained to all the tables, views etc... so if it
didn't exist then you'd be rather stuck
pg_toast just stores variable length datatypes which are greater than a
certain length.
Of course if you are using pg 7.2 or earlier then there will be no schemas.
You may be better asking this sought of question on pgsql-general rather
than pgsql-cygwin
hth,
- Stuart
P.S. Sorry for the format change the disclaimer adder forces :(

> -----Original Message-----
> From: Litel Wang [mailto:wlxyk(at)vip(dot)163(dot)com]
> Sent: 15 July 2003 09:45
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] why can't I find the other schemas in my
> restored database except public schemas ?
>
>
> 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 .
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

DISCLAIMER:The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.