Skip site navigation (1) Skip section navigation (2)

Creating related tables

From: Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating related tables
Date: 2005-10-19 12:34:20
Message-ID: 20051019123420.65330.qmail@web34413.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi 

I need to create 1:N related tables .

eg.: table A and a table B.
- table B will have motorcicles 
- table A will have motorcicles owners 
If a owner is deleted from the table A i need to
delete all the motorcicles with the deleted owner id
in the B table. 

What is the sintax in postgesql todo this  ?

Ângelo Marcos Rigo
AMR Informática 
(51) 3348 0870 
Rua Pe. Alois Kades 400/210 
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo(at)yahoo(dot)com(dot)br
 



	



	
		
_______________________________________________________ 
Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe! http://yahoo.fbiz.com.br/

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2005-10-19 13:06:49
Subject: Re: Creating related tables
Previous:From: Mogin MohandasDate: 2005-10-19 02:26:54
Subject: bit map indexes in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group