Re: advice on setting up schema sought - Mailing list pgsql-novice

From
Subject Re: advice on setting up schema sought
Date
Msg-id 20060412060533.97876.qmail@web33311.mail.mud.yahoo.com
Whole thread Raw
In response to Re: advice on setting up schema sought  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
--- Bruno Wolff III <bruno@wolff.to> wrote:

> On Tue, Apr 11, 2006 at 14:01:08 -0700,
>   operationsengineer1@yahoo.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

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to query for Interval
Next
From: Jonathan Tse
Date:
Subject: Configure command from a precompiled package