Trying to rename a postgres database:
$ psql -d some_other_database
some_other_database=# ALTER DATABASE myapp_development RENAME TO myapp_development_old
some_other_database-# \l
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------------------------------+---------+----------+-------------+-------------+---------------------
myapp_development | rails | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
No feedback whatsoever after ALTER DATABASE...! I am logged in as a Superuser and not aware of any current connections (but not sure how to be certain of that). What am I missing?
Edit: I erroneously transcribed my prompt in my original question so 2nd line had =# when, indeed (thanks Daniel), it should have had -#. Fixed above, now.
