From jkanter@virginia.edu Wed Jun 2 18:00:59 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3CAB5D1B189 for ; Wed, 2 Jun 2004 15:00:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35393-10 for ; Wed, 2 Jun 2004 18:00:59 +0000 (GMT) Received: from unix.mail.Virginia.EDU (unix.mail.Virginia.EDU [128.143.2.28]) by svr1.postgresql.org (Postfix) with ESMTP id F0982D1CF05 for ; Wed, 2 Jun 2004 15:00:55 -0300 (ADT) Received: from smtp.mail.Virginia.EDU (smtp.mail.Virginia.EDU [128.143.22.52]) by unix.mail.Virginia.EDU (Postfix) with ESMTP id 0243EABD0 for ; Wed, 2 Jun 2004 14:00:55 -0400 (EDT) Received: from virginia.edu (d-137-133-128.bootp.Virginia.EDU [137.54.133.128]) by smtp.mail.Virginia.EDU (Postfix) with ESMTP id 956512102C for ; Wed, 2 Jun 2004 14:00:55 -0400 (EDT) Message-ID: <40BE16AD.4040404@virginia.edu> Date: Wed, 02 Jun 2004 14:04:29 -0400 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres Admin List Subject: rename Content-Type: multipart/alternative; boundary="------------070807070108020608080207" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/12 X-Sequence-Number: 13672 This is a multi-part message in MIME format. --------------070807070108020608080207 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Is it possible to simply rename a database without affecting the structure of it? -- /_______________________________ //Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu / / / / / --------------070807070108020608080207 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Is it possible to simply rename a database without affecting the structure of it?
--
________________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

--------------070807070108020608080207-- From Troy.Campano@LibertyMutual.com Wed Jun 2 18:11:26 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C3112D1B189 for ; Wed, 2 Jun 2004 15:11:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44603-06 for ; Wed, 2 Jun 2004 18:11:27 +0000 (GMT) Received: from prometheus.lmig.com (prometheus.lmig.com [143.115.171.136]) by svr1.postgresql.org (Postfix) with ESMTP id 38733D1B173 for ; Wed, 2 Jun 2004 15:11:24 -0300 (ADT) Received: from LM-EXIMS-02.lm.lmig.com (SMTP4 [147.179.184.111]) by prometheus.lmig.com (8.12.10+Sun/8.12.10) with ESMTP id i52IBNqt027010; Wed, 2 Jun 2004 14:11:24 -0400 (EDT) Received: from LM-EXMSG-07.lm.lmig.com ([147.179.184.98]) by LM-EXIMS-02.lm.lmig.com with Microsoft SMTPSVC(5.0.2195.5329); Wed, 2 Jun 2004 14:11:24 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6511.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C448CD.03A5EE99" Subject: Re: rename Date: Wed, 2 Jun 2004 14:11:23 -0400 Message-ID: <82C3FD729CFA504CA44E7D32BDED411F0A2EF550@lm-exmsg-07.lm.lmig.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] rename Thread-Index: AcRIzKhPxxjU01yRSm+rsUifpFpccgAAEW5g From: "Campano, Troy" To: "Jodi Kanter" Cc: X-OriginalArrivalTime: 02 Jun 2004 18:11:24.0316 (UTC) FILETIME=[03D765C0:01C448CD] X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/13 X-Sequence-Number: 13673 This is a multi-part message in MIME format. ------_=_NextPart_001_01C448CD.03A5EE99 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable This should be what you need... http://www.postgresql.org/docs/current/interactive/sql-alterdatabase.htm l =20 =20 =20 =20 Thank you! Troy Campano=20 Liberty Mutual=20 =20 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jodi Kanter Sent: Wednesday, June 02, 2004 2:04 PM To: Postgres Admin List Subject: [ADMIN] rename =20 Is it possible to simply rename a database without affecting the structure of it? --=20 _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu ------_=_NextPart_001_01C448CD.03A5EE99 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ________________________________

This should be what you need…
http://www.postgresql.org/docs/current/interactive/sql-alterdatabas= e.html

 

 

 

 

Thank you!

Troy Campano
Liberty Mutual=
 

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] = On Behalf Of Jodi Kanter
Sent: Wednesday, June 02, 20= 04 2:04 PM
To: Postgres Admin List
Subject: [ADMIN] rename

 

Is it possible to= simply rename a database without affecting the structure of it?

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

------_=_NextPart_001_01C448CD.03A5EE99--