Determine whether constraint name is system generated in Postgres

Question

I am trying to find if a constraint name is 'system generated' or 'manually given at the time of creation'.

MS SQL Server has a column 'is_system_named' in sys.key_constraints:

1 = Name was generated by system.
0 = Name was supplied by the user.

I tried to find similar in information_schema.table_constraints. Could not find it.

Use case is basically while migrating the databases, if manually named constraints are present then it will be easy to verify.

Erwin Brandstetter · Accepted Answer · 2014-07-25 19:24:09Z

1

There is nothing of the sort in the relevant system catalog pg_constraint.

You can check the default naming pattern and if you see a different name, you can be sure it has been named explicitly. Other than that, I don't think you can tell for sure.

answered Jul 25, 2014 at 19:24

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Determine whether constraint name is system generated in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related