pgadmin4
pgadmin4 copied to clipboard
Create self-referencing foreign keys during table creation
Right now, during the creation of a table you can add the foreign key constraint to columns within your table. While this works for foreign keys that reference other tables, you are unable to a column within the table being created. This would be useful for when a parent-child relationship is needed, such as a nested comment or a manager and employees, where different columns would link with each other
Right now you need to create the table and add the constraints afterwards, this would be a simple QOL feature
To refer the table that is being created, add dropdown item like <self>.