Re: public schema doubt
| От | mailtolouis2020-postgres@yahoo.com |
|---|---|
| Тема | Re: public schema doubt |
| Дата | |
| Msg-id | 626731.97403.qm@web30410.mail.mud.yahoo.com обсуждение исходный текст |
| Ответ на | public schema doubt (mailtolouis2020-postgres@yahoo.com) |
| Ответы |
Re: public schema doubt
|
| Список | pgsql-general |
Hello Martin,
Yes, SHOW search_path show this
"$user",public .
Oh yes, I get it now, the "$user" will take priority.
Another question, this public schema, in the usual practice way, do you delete it or just leave it there and create your own schema?
Regards
Louis
----- Original Message ----
From: Martin Gainty <mgainty@hotmail.com>
To: mailtolouis2020-postgres@yahoo.com
Sent: Friday, November 16, 2007 3:17:40 PM
Subject: RE: [GENERAL] public schema doubt
.hmmessage P
{
margin:0px;padding:0px;}
body.hmmessage
{
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}
Hello Louis
SHOW search_path
if public is not on search_path or does'nt come first then
SET search_path TO public,$user;
HTH/
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now!
From: Martin Gainty <mgainty@hotmail.com>
To: mailtolouis2020-postgres@yahoo.com
Sent: Friday, November 16, 2007 3:17:40 PM
Subject: RE: [GENERAL] public schema doubt
SHOW search_path
if public is not on search_path or does'nt come first then
SET search_path TO public,$user;
HTH/
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
.ExternalClass DIV {} Hello,I did a migration from 8.2.4 to 8.2.5, I used pg_dumpall to backup all the db and then restore it into 8.2.5. In my 8.2.4 db, I don't have public schema (it was dropped when I create the db, so only myschema is there), but when I restore to 8.2.5, I found that it created a public schema for me. So why it doing this for me? I thought it should restore back excatly the same what I backup from 8.2.4?Should I just let the public schema there? Will it cause any problem? In the postgres doc http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html (5.7.2) it said if I create a table without specify any schema name, it will put it into public schema, so I test it in my case, but it not doing it, the table is create under myschema, strange. And I check the search_path, it show "$user",public .Could someone explain it to me?ThanksLouis
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now!
В списке pgsql-general по дате отправления: