Thread

1. How to rename a database?

   Farzad FARID <farzy@publicis.fr> — 1998-07-08T14:09:46Z

   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
   
   
   

2. Re: [GENERAL] How to rename a database?

   Aleksey Dashevsky <postgres@luckynet.co.il> — 1998-07-09T08:56:53Z

   Use following syntax:
   alter table <Old_Table_Name> rename to <New_Table_Name>
   
   Al.
   
   On Wed, 8 Jul 1998, Farzad FARID wrote:
   
   > 
   > 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
   > 
   > 
   
   
   

3. Re: [GENERAL] How to rename a database?

   James Oden <joden@lee.k12.nc.us> — 1998-07-09T16:44:33Z

   > 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
   > >
   > >