How to display constraint using ESQL/C?

Question

I have to output the constraint in my PostgreSQL using ESQL/C that I have set before directly with SQL. Below is the constraint I need to print out.

ALTER TABLE p
ADD CONSTRAINT check_name_of_det 
CHECK ((name = 'Screw' AND n_det = 'P6') OR n_det <>'P6');

In case I'm trying to execute sql query to the table with constraint. When I operate this I attain sqlca.sqlcode == -400 therefore I have to print out constraint that this table has. — karver35, Oct 29 '21 at 14:02

score 1 · Accepted Answer · answered Oct 29 '21 at 14:16

1

You can use the pg_get_constraintdef function. The argument is the object ID from pg_constraint.

answered Oct 29 '21 at 14:16

Laurenz Albe

1 Answers1