May I have an assistance on CREATE TABLE Command

From: James Kitambara <jameskitambara(at)yahoo(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: May I have an assistance on CREATE TABLE Command
Date: 2008-09-17 06:50:51
Message-ID: 792455.42335.qm@web27908.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

 
Hello Mambers of PGSQL-SQL,
 
I have two tables namely:
 
    REGION (region_id, region_name)
    DISTRICT (dist_id, dist_name, region_id (FK))
 
I would like to have the CREATE TABLE Command which will create these tables in such a way that when REGION table is UPDATED automatical the FOREGN KEY in DISTRICT  table is also updated.
 
I will appriciate for your assistance !

Regards
 
James Kitambara

 

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2008-09-17 08:36:49 Re: May I have an assistance on CREATE TABLE Command
Previous Message Michael Toews 2008-09-17 06:50:21 Re: Insert a space between each character