I'm trying to set up some kind of constraint so that I can only enter values in "Table A", if that value exists in "Table B".

I want this to act sort of like a selection list, where there are only a few values that exist in "Table B", which then restricts the values that can be entered into "Table A". (Kind of like a drop down list/ selection list)

I'm using pgAdmin 4 to access a PostGIS DB

closed as off-topic by Vince, TomazicM, LaughU, Fran Raga, ThingumaBob Sep 4 at 8:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – Vince, TomazicM, LaughU, Fran Raga, ThingumaBob
If this question can be reworded to fit the rules in the help center, please edit the question.