Re: Schema design question - Mailing list pgsql-general

From Matt Miller
Subject Re: Schema design question
Date
Msg-id 1124314504.3074.67.camel@dbamm01-linux
Whole thread Raw
In response to Re: Schema design question  (Bill Moseley <moseley@hank.org>)
List pgsql-general
On Wed, 2005-08-17 at 13:40 -0700, Bill Moseley wrote:
> a course
> and class share so many columns.  ...and
> I worry about changing a column type on one table and forgetting to
> change it on the other table.

Postgres types might help here.  You could probably create a type that
contains the common columns, and then embed that type where you need it.

pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Re: speeding up a query on a large table
Next
From: Fernando Lujan
Date:
Subject: Re: [despammed] Generating random values.