pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Create self-referencing foreign keys during table creation

Open Jacob-P-Busby opened this issue 1 year ago • 1 comments

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

Jacob-P-Busby avatar Dec 02 '24 15:12 Jacob-P-Busby

To refer the table that is being created, add dropdown item like <self>.

yogeshmahajan-1903 avatar Dec 06 '24 11:12 yogeshmahajan-1903