<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.1020701@virginia.edu"type="cite"></blockquote> I thought there was an option to rename a database? I
cannotseem 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
bringour sytem down to upgrade the release this afternoon. There are a number of db changes taking place so I was
thinkinginstead of taking the system down for an extended amount of time I could build another database with all our
newitems 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 /></div><div class="Section1"><p class="MsoNormal"><i><span
style="font-size:9pt; font-family: Arial;">_______________________________<br /></span></i><i><span style="font-size:
10pt;">JodiL Kanter<br /> BioInformatics Database Administrator<br /> University of Virginia<br /> (434) 924-2846<br
/><ahref="mailto:jkanter@virginia.edu100">jkanter@virginia.edu</a></span></i><p class="MsoNormal"> </div><br /><br
/><preclass="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>
