On Fri, Oct 10, 2008 at 3:38 AM, gorsa <gorsa.1972@xxxxxxxxx> wrote: > hi all > is there a way to get a unique identifier for a client? something like > a machine id. session_user does not seem to work since a user can log > on to many workstations. been through the list so i'm not searching > for getting the ip address since the list said something like it's not > supported in unix-sockets, though i'll take it since i'm using > postgres in windows environment. thanks in advance :) Does this unique identifier need to be something with permanence from one connection to the next? If not, then select * from pg_stat_activity should have uniquely identifying information in it. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
