O$: PostgreSQL setting the $programname property

Alex Clay aclay at mac.com
Mon Nov 6 10:48:25 UTC 2023

Hi Paul,

We set the application_name value on the connection before logging in to affect pg_stat_activity. For example:

Calculate voSession.$options as "application_name='my great app'"

You can combine this with other settings, such as sslmode.

This needs to be set before calling $logon.

I haven't used $programname, but it looks to do the same as setting application_name. Are you setting $programname before logging on?


> On Nov 6, 2023, at 02:25, Paul Mulroney <pmulroney at logicaldevelopments.com.au> wrote:
> Hi Everyone,
> Has anyone tried to use the $programname property of a PGSession object?  I'd like to tell Postgres the application that's running (eg Omnis), so that I can see it in the pg_stat_activity table, but I can't seem to get it to work.
> I'm basically doing this:
> Calculate voSession.$programname as 'Fred'
> Am I missing anything?
> Regards,
> Paul.
> I remember the first time I saw a universal remote control … I though to myself "Well, this changes everything"
> -- 
> Paul W. Mulroney                                            We Don't Do Simple Pty Ltd 
> pmulroney at logicaldevelopments.com.au       Trading as Logical Developments
> www.logicaldevelopments.com.au                   ACN 161 009 374 
> Ph: +61 8 9458 3889                                       86 Coolgardie Street
>                                                                         BENTLEY  WA  6102
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

More information about the omnisdev-en mailing list