Forum Discussion

RStelzig's avatar
RStelzig
New Contributor
3 years ago

Is it possible to perform an upsert to Postgres in SnapLogic?

Hi Everyone, Is there an option to configure an existing Postgres snap to perform an upsert to a given table? I am building a pipeline to create a daily feed to a postgres database and would like...
database
RStelzig's avatar
RStelzig
New Contributor
2 years ago

Hi rriley99 ,

I did find a solution that I have been using for almost a year without error. It's similar to alchemiz  suggestion below which I haven't tried yet but will definitely check out in the future.

I am using a slightly different approach on the scripting as I am using a staging table in my database.  In the Postgres - Execute Snap I am using the following:

Hope that is helpful to you!

rriley99's avatar
rriley99
New Contributor III
2 years ago

This was exactly what I was going to try when I got to that stage. I will write back once I get there!