From: | Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Create Table |
Date: | 2001-11-13 13:33:05 |
Message-ID: | Pine.LNX.4.20.0111131126160.26248-100000@ni.hmmg.sp.gov.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I know it is a really single question, but I am without any
reference... Does anyone can help me ?
I have to tables (example): 'seller' and 'sells'
seller:
CodSeller | NameSeller
----------------------
1435 | Mark
2486 | Tim
Sells:
CodSell | CodSeller | Description
---------------------------------
001 | 1435 | xya sfaks
002 | 2486 | sdf sdfsd
So, I can create seller like:
create table seller (codseller integer, nameseller char(35));
My question is how to create 'Sells' and link it with 'Seller', can I
force delete cascades with this relation ?
Thanks in Advance,
See ya,
Marcelo
From | Date | Subject | |
---|---|---|---|
Next Message | Mirko Zeibig | 2001-11-13 13:34:54 | Re: Sourceforge on Oracle? |
Previous Message | Mike Mascari | 2001-11-13 12:30:56 | Behavior of nextval() and currval() |