5 min Logic App PSQL – e-lo [IT Engineer life]

If we move on from

Lets add a Postgres Database.

Install from market, then we get

Now let’s edit the logic app, and postgres connector

You get, delete, get, insert and much more. lets do insert, but first set connection

I have already create a dbtest, table company and a user joe with grant

Now lets upload a file, and also delete the teams trigger.

We now listen for a new file, post a msg to queue and insert a row in the db, lets do that.

(Note: had to change the ID since it is SERIAL in the table, set 100)

rm rg test-psql

Info