Re: advice on setting up schema sought

--- 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