On Wed, Feb 3, 2021 at 8:23 AM Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
wrote:
> Hello,
>
> I’ve got a table name publication, and another table named
> publication_item.
> Each publication_item is linked to a publication by publication_id.
> How could I add a constraint that check each publication has one or more
> publication_item when a tuple is inserted ?
> I don’t want to store items in the same table as publication because we
> could have 1-> n items.
>
https://www.postgresql.org/docs/current/tutorial-fk.html
David J.