I'm relatively new to postgres. We have some fields that are varchars but have check constraints. Is there a way to view the contraints for that field?
Please try Copy DDL action from the table context menu, or/and DDL tab in Table Editor (Table Editor context menu action) for the table. There, however could be an issue with check constrains when displaying the DDL for tables: https://youtrack.jetbrains.com/issue/DBE-1010 .
Hello Todd,
Please try Copy DDL action from the table context menu, or/and DDL tab in Table Editor (Table Editor context menu action) for the table. There, however could be an issue with check constrains when displaying the DDL for tables: https://youtrack.jetbrains.com/issue/DBE-1010 .
I guess there is indeed a bug. copying the ddl produces the same output as the ddl tab. i guess i'll wait on a fix.
Thanks