Re: Optional postgres database not so optional in 8.1 - Mailing list pgsql-hackers

From Michael Paesold
Subject Re: Optional postgres database not so optional in 8.1
Date
Msg-id 008101c5eb8b$80411ea0$0f01a8c0@zaphod
Whole thread Raw
In response to Optional postgres database not so optional in 8.1  ("John Hansen" <john@geeknet.com.au>)
Responses Re: Optional postgres database not so optional in 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Joshua D. Drake wrote:

>> psql -l; ignores -dtemplate1, and createdb doesn't have such an option.
>>
> I can't test createdb here but on the psql... what happens if you just:
>
> psql -Upostgres template1?

It's the '-l' option (list all databases) that does not honor the database 
given on the command line.

This does not work, if the postgres database is dropped in 8.1:

psql -l template1
psql -l -d template1

of course "psql template1" will just work fine.

Best Regards,
Michael Paesold 




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: CLUSTER and clustered indices
Next
From: Tom Lane
Date:
Subject: Re: CLUSTER and clustered indices