Mapping two table primary keys together - Mailing list pgsql-novice

From Mike Friesen
Subject Mapping two table primary keys together
Date
Msg-id Pine.LNX.4.30.0102261156390.8744-100000@mike.pmcanada.com
Whole thread Raw
List pgsql-novice
I have 2 table with the same primary key.  If I try and do a join on them,
it is very slow unless I explicitly specify in my select statement that
those two keys are equal.  Is there any way to tell postgresql internally
that those two primary keys are equal?  Basically so that in my select
statement I don't have to always specify those keys as equal.

Thanx..

Mike


pgsql-novice by date:

Previous
From: Adam Lowry
Date:
Subject: selecting using WHERE on arrays
Next
From: "Mark, Terry"
Date:
Subject: RE: copying tables