Viewing check constraints

Avatar
Permanently deleted user
Created

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

Votes

1

Share

2 comments
Avatar
Andrey Dernov
Created

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 .

1
Avatar
Permanently deleted user
Created

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.