Re: advice on setting up schema sought

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

In response to

Browse pgsql-novice by date

  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