Thread: RE: [GENERAL] How to rename a database?

RE: [GENERAL] How to rename a database?

From
"Jackson, DeJuan"
Date:
try:
 pg_dump <old_database> > tmp.sql
then edit tmp.sql to change the old_database name to new_database name.
then:
 cat tmp.sql | psql template1
    -DEJ

> -----Original Message-----
> From:    James Olin Oden [SMTP:joden@Lee.k12.nc.us]
> Sent:    Thursday, July 09, 1998 11:45 AM
> To:    Aleksey Dashevsky
> Cc:    Farzad FARID; pgsql-general@postgreSQL.org
> Subject:    Re: [GENERAL] How to rename a database?
>
>
> > 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
> > >
> > >
>
>
>