From: | jaggybala(at)yahoo(dot)com (Jagdeesh) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to relate an attribute of one table with the attributes of another related table |
Date: | 2003-08-12 23:42:24 |
Message-ID: | 96e27709.0308121542.73db5cc9@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everyone,
I am a new user of postgresql... I have to create a table named person
like:
create table person (
personname varchar(40),
telefonnumber varchar(20)
);
Now, I have to create tables for personname and telefonnumber like:
create table personname (
firstname varchar(20),
lastname varchar(20)
);
and,
create table telefonnumber (
countrycode varchar(20),
areacode varchar(20),
number int4
);
Now, when the personname table has attributes:
firstname = 'John'
lastname= 'Paul'
and similarly somevalues for telefonnumber table,
i must have the value of personname attribute in person table as 'John
Paul' and the telefonnumber attribute of person table must be the
integration of attributes in the telefonnumber table.
Pls. guide me how to make this possible?...Is there any way to do so?
Thanx for spending ur valuable time and waiting for ur reply.
regards,
Jaggy Bala.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2003-08-12 23:43:10 | Re: PostGreSQL - Accessing It |
Previous Message | Maksim Likharev | 2003-08-12 23:30:08 | Re: Sorting Problem |