>It isn't consistent but it's by purpose. And there's a really good reason for >that behaviour. There's no issue with psql connecting to a >default database >because psql doesn't do anything by itself. pg_restore will do something to >the database it connects to. It might drop >some objects, create some, add >data. I want to be sure it's restored in the right database. I don't want it >to second-guess what I want to >do. Otherwise, I'll have a really hard time >fixing everything it did. So -d is required by pg_restore to connect to some >database, >whereas there's no big deal with psql connecting to a default >database.
Ok, makes sense. Thanks all for your answers Regards Daniel
