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

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