Creating users with name and email

From: Andreas Burkhardt <rootshell(at)web(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating users with name and email
Date: 2006-06-02 17:43:38
Message-ID: 4ebblcF1dl0m6U1@uni-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Normally php programers create a table 'users' with name and password. But
the real access will be done allways with the same (super)user and
password. This is less secure and a bad design, too.

So ich pass the user thru php to the database. But I want to have additional
entrys for my users like the full name und the e-mail address.

How will I handle this the best way in postgresql:

1. adding the new columns to pg_authid?

2. CREATE TABLE users (
email VARCHAR ) INHERITS (pg_authid);

3. CREATE TABLE users (
rolname VARCHAR REFERENCES pg_authid ( rolname ),
email VARCHAR );

4. ???

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tobias Boes 2006-06-02 18:28:18 multiple psql commands in batch
Previous Message Tom Lane 2006-06-02 16:40:47 Re: Locale and Initdb Errors