Обсуждение: when can I find template1 in pgadmin II?

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

when can I find template1 in pgadmin II?

От
"LitelWang"
Дата:
Is this question strange?I think so .I installed postgres
on cygwin platform for 3 times .There was one time I found template1
in database item of pgadmin II .It showed there were three databases,
and actually I created one for my development .The other two are 
tempalte0 and template1 .But now I couldn't let this appear again 
whatever I tried .Who can tell me the truth?
Some details:I even found some other schemas except "public" in my own 
database .I didn't create any schemas in it .after I backuped it and restored
it on another system with same configuration I couldn't find those schemas
except "public" again .
If there is any advice  please let me know .Thanks .  




Re: when can I find template1 in pgadmin II?

От
"George Weaver"
Дата:
If you want to see ALL schemas - make sure System Objects is checked under
View. Unchecking System Objects only shows the schemas you've created.

George

----- Original Message ----- 
From: "LitelWang" <wlxyk@vip.163.com>
To: <pgadmin-support@postgresql.org>
Sent: Monday, July 28, 2003 12:00 AM
Subject: [pgadmin-support] when can I find template1 in pgadmin II?


> Is this question strange?I think so .I installed postgres
> on cygwin platform for 3 times .There was one time I found template1
> in database item of pgadmin II .It showed there were three databases,
> and actually I created one for my development .The other two are
> tempalte0 and template1 .But now I couldn't let this appear again
> whatever I tried .Who can tell me the truth?
> Some details:I even found some other schemas except "public" in my own
> database .I didn't create any schemas in it .after I backuped it and
restored
> it on another system with same configuration I couldn't find those schemas
> except "public" again .
> If there is any advice  please let me know .Thanks .
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>