Re: Foreign key joins revisited - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: Foreign key joins revisited
Date
Msg-id 287c0a1b-d499-4ff6-a625-539801f42bd0@www.fastmail.com
Whole thread Raw
In response to Re: Foreign key joins revisited  (Sascha Kuhl <yogidabanli@gmail.com>)
List pgsql-hackers
On Sun, Dec 26, 2021, at 19:54, Sascha Kuhl wrote:
> Could you make
>
> JOIN key ?

Not sure what you mean.
Perhaps you can explain by rewriting the normal query below according to your idea?

SELECT *
FROM permission p
LEFT JOIN role r ON p.role_id = r.id

Given the foreign key on "permission" that references "role" is named "permission_role_id_fkey".

/Joel

pgsql-hackers by date:

Previous
From: Sascha Kuhl
Date:
Subject: Re: Foreign key joins revisited
Next
From: Isaac Morland
Date:
Subject: Re: Foreign key joins revisited