public schema doubt

From: mailtolouis2020-postgres(at)yahoo(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: public schema doubt
Date: 2007-11-16 14:56:10
Message-ID: 606296.12175.qm@web30411.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks
Louis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pau Marc Munoz Torres 2007-11-16 15:08:14 Re: moving from mysql to postgree
Previous Message Douglas McNaught 2007-11-16 14:54:54 Re: postgres 8 on solaris 9