#1
  1. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18

    Renaming a database.


    If I want to rename a database for PG 7.1.3 can I just update datname in pg_database, or is there some other way (or more things I need to do) of doing it?

    Thx,
    -b
    PostgreSQL, it's what's for dinner...
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    Why not try that with a small test database (after doing a complete backup of all PG first to be sure)?
  4. #3
  5. Kiss My Converse!
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    May 2003
    Location
    Davie, Florida
    Posts
    1,520
    Rep Power
    338
    Bcyde, did you get this resolved?
  6. #4
  7. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18

    Yup


    Sorry for not replying sooner, was out of town for a bit, updating datname did the trick for me.

    -b
    PostgreSQL, it's what's for dinner...

IMN logo majestic logo threadwatch logo seochat tools logo