Viewing check constraints

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?

 

Thanks

2 comments

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 .

0

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

0

Please sign in to leave a comment.