Posts

Showing posts with the label postgresql-10

Why do we need template0 and template1 on postgresql?

Why do we need template0 and template1 on postgresql? I'm a beginner on postgresql. I have faced many difficulties while installing and connecting the database with the pgadmin, I learned a lot of things from the mistakes I do. Now my doubt is why should the l shows the template0 and template1, I searched on the web but unfortunately I didn't find the rightful resources, but I can find that after the removal of both DB(template0 & template1) we cant create a Database. I don't know how you searched for it, this is literally the first and second results in google for "template0". – eurotrash Jul 1 at 10:44 1 Answer 1 As the name indicates, those are template databases for creating new databases. template1 is the one used by defau...