Ted Byers <r.ted.byers@xxxxxxxxxx> writes: > OK, Now I am a bit confused. The manual doesn't say > what to do if you don't see template1 or template0 on > the server, or even whether or not you should be able > to see them when using a tool like pgAdmin. Our manual is not in charge of documenting pgAdmin. Perhaps you should go to the pgadmin lists and discuss with them whether auto-hiding these databases is such a good idea. Or at least dare to touch "psql -l" so that you can find out whether pgAdmin is hiding them or not. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match