From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | danmcb <danielmcbrearty(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: advice on setting up schema sought |
Date: | 2006-04-12 06:05:33 |
Message-ID: | 20060412060533.97876.qmail@web33311.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--- Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Tue, Apr 11, 2006 at 14:01:08 -0700,
> operationsengineer1(at)yahoo(dot)com wrote:
> > like so?
> >
> > t_translations
> > language_id (used for table level pkey)
> > base_text_id (used for table level pkey)
> > translation (text)
> >
> > i haven't worked with table level pkeys before.
> next
> > time i get pgadmin3 fired up, i'll look into it.
>
> Here is an example of a table constraint right from
> the documentation:
> CREATE TABLE films (
> code char(5),
> title varchar(40),
> did integer,
> date_prod date,
> kind varchar(10),
> len interval hour to minute,
> CONSTRAINT code_title PRIMARY KEY(code,title)
> );
>
cool beans! but my mysql friends tell me pgsql is
slow... is it?
juuuuuust kidding!
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Tse | 2006-04-12 06:39:05 | Configure command from a precompiled package |
Previous Message | A. Kretschmer | 2006-04-12 05:30:03 | Re: How to query for Interval |