Attaching information about users

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Attaching information about users
Date: 2007-11-01 11:01:34
Message-ID: 200711011101.35959.david.goodenough@btconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the proper way to attach additional information about users of
a database. That is to say I am using their DB login as their application
ID, and I need to have one or more tables which remember preferences and
other application level things, but the key is their current userid and
I want to be sure that I only have entries for people who are currently
users in this DB. I suppose what I want to do is to use foreign key
constraints, but that would be to a postgresql specific table (I guess,
or is the table that holds the list of IDs and its field names common
across DBs?).

David

Browse pgsql-general by date

  From Date Subject
Next Message dhiraj bhosale 2007-11-01 11:15:37 If Postgresql DLL files causing any kind of conflict for two different versions of Postgresql installed on one machine
Previous Message yogesh 2007-11-01 10:38:48 Number to Words Conversion