How to rename a database?
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
Use following syntax:
alter table <Old_Table_Name> rename to <New_Table_Name>
Al.
On Wed, 8 Jul 1998, Farzad FARID wrote:
Show quoted text
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
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...
Show quoted text
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
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
Show quoted text
-----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
Import Notes
Resolved by subject fallback