Address Table - Mailing list pgsql-novice

From Rudi Starcevic
Subject Address Table
Date
Msg-id 3EFB7CDD.30306@oasis.net.au
Whole thread Raw
Responses Re: Address Table  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: Address Table  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Hi,

This one's any easy one I think.

Say I have a table of Parks - parks_table.

Each Parks has an address.

If each Parks has *one and one only* address
is it better to store the address in the parks_table
or build another table just for Parks addresses - parks_address ?

If I have two tables would you put the parks_table primary key in the
parks_address table or the other way round ie. the parks_address primary
key in the parks_table ?

Thanks
Regards Rudi.


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Greater than a value
Next
From: Nabil Sayegh
Date:
Subject: Re: Address Table