City of Arabel
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    HOW TO: Change PC Name in CNR DB

    Scheduled Pinned Locked Moved Server Management
    1 Posts 1 Posters 27 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • EchoE
      Echo
      last edited by Echo

      From PUTTY
      type:

      psql <enter>
      select * from cnr_misc order by tag; <enter>
      

      use space bar to scroll through names until you find the one you want
      highlight the name to copy it
      type: q (to return to main screen)
      type:

      update cnr_misc set tag = 'NEW NAME' where tag = 'OLD NAME'; <enter>
      

      "You can complain if you weren't asked; you can't complain if you were asked but didn't contribute." ~ Professor.

      1 Reply Last reply Reply Quote
      • EchoE Echo pinned this topic on
      • folkloreF folklore moved this topic from Team Lead Forums on
      • folkloreF folklore moved this topic from DM Instructions & Requests on
      • 1 / 1
      • First post
        Last post