what's the right way to rename a database then?
On Feb 6, 2008 5:33 PM, Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > Nuwan Liyanage wrote: > > Ok I think I got it. I just went ahead and updated the pg_database table > > and it works.. > > > > A better way is to connect to another database (template1 for exemple, > but you would better use another one) and fire your statement there. > > Updating system table can be dangerous. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >