I primarily use pgcli service=svc_name to start pgcli with everything defined in ~/.pg_service.conf. I would like the ability for that service name to appear in the prompt. I currently use \h to show the hostname, but but our hosts are things like psql-dept-tier-azflexdb-application, and I'd much prefer to just see my svc_name in the prompt.
It looks like prompt_dsn is only provided to the PGCli class for the purpose of displaying in the prompt. If we're connecting to a service name, that value could be provided instead, perhaps?
I could just redefine the services as alias_dsn, but we use other tools that use the standard pg_service file, so I really don't want to define them twice.
I primarily use
pgcli service=svc_nameto start pgcli with everything defined in~/.pg_service.conf. I would like the ability for that service name to appear in the prompt. I currently use\hto show the hostname, but but our hosts are things likepsql-dept-tier-azflexdb-application, and I'd much prefer to just see mysvc_namein the prompt.It looks like
prompt_dsnis only provided to thePGCliclass for the purpose of displaying in the prompt. If we're connecting to a service name, that value could be provided instead, perhaps?I could just redefine the services as
alias_dsn, but we use other tools that use the standard pg_service file, so I really don't want to define them twice.