Need help form inherits

From: Patrice OLIVER <oliverp21(at)free(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Need help form inherits
Date: 2004-08-01 16:07:34
Message-ID: 410D1546.2060607@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello everybody,

I would like to use inherits between 2 tables :

user(login,password)

and

studiant(firstname, lastname, email)

these tables are created like this :

create table user (
login varchar(15) not null primary key,
password varchar(32));

create table studiant (
firstname varchar(35),
lastname varchar(35),
email varchar(255)
) inherits user;

The problem is that a studiant can become a user of the site to consult
its results. Members of user table are actually secretaries, who
administer exams ...

so, if I create un user :

insert into user values ('por',md5('tototo'));

and I want know to say that the user 'por' becomes a studiant. How can I
do this ?
In the other way, to say that a studiant is also a user, I just have to do :

insert into studiant
('kml',md5('tititi'),'Michel','Michelle','michelle21(at)dynu(dot)com');

And all is ok.

Thanks for your help.

Patrice

Attachment Content-Type Size
oliverp21.vcf text/x-vcard 124 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2004-08-02 04:25:41 Re: How to create an aggregate?
Previous Message Tom Lane 2004-07-31 00:50:39 Re: How to create an aggregate?