| From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: db rename |
| Date: | 2004-10-25 13:12:21 |
| Message-ID: | 417CFBB5.9090907@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt><br>
Dear Jodi,<br>
<br>
<br>
psql>\h CREATE DATABASE<br>
Command: CREATE DATABASE<br>
Description: create a new database<br>
Syntax:<br>
CREATE DATABASE name<br>
[ [ WITH ] [ OWNER [=] dbowner ]<br>
[ LOCATION [=] 'dbpath' ]<br>
[ TEMPLATE [=] template ]<br>
[ ENCODING [=] encoding ] ]<br>
<br>
tradein_clients=#<br>
<br>
</tt><br>
You might consider using the TEMPLATE=template option<br>
by default its template1 , if you put the existing database name<br>
a replica of specified database is made<br>
<br>
Hope it helps.<br>
<br>
Regds<br>
Mallah.<br>
<br>
Jodi Kanter wrote:
<blockquote cite="mid417CF897(dot)1020701(at)virginia(dot)edu" type="cite">
<meta http-equiv="Content-Type" content="text/html;">
<title></title>
I thought there was an option to rename a database? I cannot seem to
find the syntax in any of my books or on the web site. Am I incorrect?
We are running 7.3.4. We have to bring our sytem down to upgrade the
release this afternoon. There are a number of db changes taking place
so I was thinking instead of taking the system down for an extended
amount of time I could build another database with all our new items
and then just rename it when we are ready.<br>
Is there a rename option out there for our version?<br>
thanks<br>
Jodi <br>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 10 (filtered)">
<title>_______________________________</title>
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><i><span
style="font-size: 9pt; font-family: Arial;">_______________________________<br>
</span></i><i><span style="font-size: 10pt;">Jodi L Kanter<br>
BioInformatics Database Administrator<br>
University of Virginia<br>
(434) 924-2846<br>
<a href="mailto:jkanter(at)virginia(dot)edu100">jkanter(at)virginia(dot)edu</a></span></i></p>
<p class="MsoNormal"> </p>
</div>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
regds
Mallah.
Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com (3,11,246) Registered Users |
| Indias' Leading B2B eMarketPlace |
| <a class="moz-txt-link-freetext" href="http://www.tradeindia.com/">http://www.tradeindia.com/</a> |
+---------------------------------------------------+
</pre>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CHRIS HOOVER | 2004-10-25 13:26:00 | Re: db rename |
| Previous Message | Jodi Kanter | 2004-10-25 12:59:03 | db rename |