#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    2
    Rep Power
    0

    Per Server PROMPT1 Changes for Remote Connections?


    All,

    I've searched high and low for this, but haven't found anything in the docs, which leads me to believe it's not implemented.

    I'd like to change the prompt for our production server to have a red background, or have "** PRODUCTION **" or something prepended to the prompt. I'm able to do that server wide via the psqlrc file, but that only works if people run psql on the server itself.

    If instead a user runs psql from their desktop, only their local config is used, which is a problem as they will access both dev, test, and live DB servers. I haven't found a way to present a unique prompt per server they access (or per DB they access).

    Is there a way to change the prompt on the server side? Per database?

    I'd appreciate any pointers,
    Nick
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    10
    So you want the server to force a prompt-color on the client?

    Have you asked this on the PostgreSQL mailinglists? Because if it's possible the makers of PostgreSQl will now...
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    2
    Rep Power
    0
    Originally Posted by Vinny42
    So you want the server to force a prompt-color on the client?

    Have you asked this on the PostgreSQL mailinglists? Because if it's possible the makers of PostgreSQl will now...
    Yes that is correct, I can ask there, but I think I've found this is just not possible. psql is a client application, and thus can only be impacted by client settings.

IMN logo majestic logo threadwatch logo seochat tools logo