Postgres Pro
Downloads
Home   >   mailing lists

Create Table - Mailing list pgsql-general

From Marcelo Pereira
Subject Create Table
Date
Msg-id Pine.LNX.4.20.0111131126160.26248-100000@ni.hmmg.sp.gov.br
Whole thread Raw
Responses Re: Create Table
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Behavior of nextval() and currval()
Next
From: Mike Mascari
Date:
Subject: Re: Create Table