Tag: postgresql-triggers

Using Triggers in PGAdmin4 v5 to get the geom of a line being generated in QGIS

postgis postgresql postgresql-triggers qgis sql

So I have a database of pipes that is visually coded in qgis. My goal is to add a trigger to PGAdmin4 v5 that uses ST_StartPoint() and ST_EndPoint() to get the end points of the polyline (the pipe) as it is being entered. Then, I was going use this geometry to grab the nearest structure (a point) and autocomplete two

How to register trigger in PostgreSQL?

postgresql postgresql-triggers sql

I have trigger and procedure. I want to be sure that string saved to database will have no ‘-‘ characters. After executing UPDATE interesant SET interesant_nip = ‘555-555-5555’ I get error …