Create Table

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

Responses

Browse pgsql-general by date

  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()