On 27 Feb 2003, Hadley Willan wrote:
> Hello,
> I'd like to rename one of my databases. Is it is simple as changing
> the datname field in the pg_databases table?
>
> If so, is it done through ALTER database or a SQL update?
The way I do it is:
# createdb newdb
# pg_dump olddb|psql -e newdb
... check to make sure it's all there working, then...
# dropdb olddb