On 27 Feb 2003, Hadley Willan wrote:
> 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
In response to
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2003-02-27 16:21:46|
|Subject: Re: index usage (and foreign keys/triggers)|
|Previous:||From: Dave Cramer||Date: 2003-02-27 15:52:18|
|Subject: phpBB2 slow on postgres vs mysql ?|