3 ms·
Postgres supports JOIN USING. If your keys are named the same in both tables, say `user_id` then you can simply say SELECT * FROM parent JOIN child USING
by jessedhillon 6y ago
Postgres supports JOIN USING. If your keys are named the same in both tables, say `user_id` then you can simply say
SELECT *
FROM parent
JOIN child USING (user_id)
I personally think naming your primary keys with their full name instead of calling all of them `id` or `key` is better practice also.