Horton

Re: [GENERAL] How to rename a database?

James Oden <joden@lee.k12.nc.us>

View thread View on postgr.es
From: James Olin Oden <joden@Lee.k12.nc.us>
To: Aleksey Dashevsky <postgres@luckynet.co.il>
Cc: Farzad FARID <farzy@publicis.fr>, pgsql-general@postgresql.org
Date: 1998-07-09T16:44:33Z
Lists: pgsql-general 
> Use following syntax:
> alter table <Old_Table_Name> rename to <New_Table_Name>
>
>

I don't think that will work for the entire database.  Remember a table is
part of the database.  So I don't think alter will change the actual
database's name...

> >
> > How do I rename an existing database? Is it enough to just rename the
> > directory? If that's the only way to do it do I have to first shut the
> > server down?
> >
> > --
> > Farzad FARID
> > Administrateur Reseau
> > Publicis Technology
> >
> >