The Hidden Databases in PostgreSQL – What template0 and template1 Are Really For

When you install PostgreSQL, three default databases are automatically created: postgres template1 template0 But here’s the strange part:You can see template1 and postgres in most tools...But template0 is nowhere to be found. Even if you run \l ...