通过pgAdmin在PostgreSQL中创建关系链接 [英] Creating relationship links in PostgreSQL via pgAdmin

问题描述

我在pgAdmin中用四个表创建了一个数据库.它是用PostgreSQL编码的.

I created a databse with four tables in pgAdmin. It was coded in PostgreSQL.

我想知道如何在pgAdmin中创建复制关系链接?我已经搜索过google和youtube，但似乎找不到关于它的教程.

I was wondering how do you create replationship links in pgAdmin? I've searched google and youtube, but can't seem to find a tutorial on it.

如果有人可以解释如何做到这一点，我将不胜感激.

If someone can explain how to do this, i'll be grateful.

这是我如何设计数据关联的图片:

Here's a picture of how I designed my datase to relate:

推荐答案

您可以通过右键单击表--> Properties --> Constraints --> Foreign Key (Add)来找到它.

You can find it via right-click on the table --> Properties --> Constraints --> Foreign Key (Add).

然后，您可以根据需要添加外键.还没有办法以图形方式完成它.

Then you can add the foreign keys as needed. There is (yet) no way to do it graphically.

这篇关于通过pgAdmin在PostgreSQL中创建关系链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！