Autogenerating SQL code for existing constraints

Question

Can I autogenerate SQL code for existing constraint in postgres and get it like the result of other sql query? Pgadmin can do it (see this picture) , but i need the sql query for constraint by it's name. Thanks in advance

Thanks Ulad Kasach for this gem: https://stackoverflow.com/a/62548144/13467309 — Hu Man, Jul 13 '20 at 23:06

score 0 · Accepted Answer · answered Jul 14 '20 at 06:31

0

You should use the pg_get_constraintdef function to construct an SQL statement for the constraint definition.

answered Jul 14 '20 at 06:31

Laurenz Albe

209,280
17
206
263

Autogenerating SQL code for existing constraints

1 Answers1