[EMAIL PROTECTED] writes: > On Thu, 16 Dec 2004, Tom Lane wrote: >> Uh ... what schemas are you expecting to find there?
> In normal cases there are: > information_schema > pg_catalog > pg_temp1 > pg_toast > public > schemas. Without them the database is not really usefull. When I > create the first database (as copy of template1 of course) it misses > those schemas. I don't know what is the normal way to create them if > `initdb' didn't do it (it just said it did...) It's difficult to believe that those aren't there, or that the database would appear to work if they were not. Are you able to do, say, "select * from pg_namespace"? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly