Skip site navigation (1) Skip section navigation (2)

user administration with photo and address

From: Andreas Burkhardt <postgresql(at)arcor(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: user administration with photo and address
Date: 2008-02-12 01:35:40
Message-ID: 47B0F7EC.6040506@arcor.de (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

normally web programmers fake a user administration in PHP and connect
to the database with one (super) user.

I'am a nice guy and pass the user through PHP directly to postgresql.

But the problem for me is, that my users have an address, preferences
and other things, wich are unknown to the pg_user table.

At the moment I have a table 'user' and bind the 'usename' with a
foreign key to the 'pg_user' table.

My question now is, may this be the best way – or – how real postgresql
programmers will do this?

Is there a manual or a best-practice for this?

Thanks in advance
Andreas

pgsql-novice by date

Next:From: AndreasDate: 2008-02-12 01:59:08
Subject: Re: Question regarding GROUP BY
Previous:From: Scott MarloweDate: 2008-02-11 21:33:37
Subject: Re: [PERFORM] Question about CLUSTER

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group