ADF does not support a built-in PostgreSQL stored procedure. As a workaround, you can consider using an Azure Function with ADF that runs the logic you want.
Don't have exact working example for this but will work mostly like:
module.exports = async function (TableName, LastModifiedDate) {
var pg = require('pg');
//const config = "postgres://<username>:<password>@<postgres servername>:5432/<database>";
const config = {
host: 'servername.postgres.database.azure.com',
user: 'user@servername',
password: <password>,
database: '',
port: 5432,
ssl: true
};
var client = new pg.Client(config);
const query = ' UPDATE mytable
SET [Value] = @LastModifiedtime
WHERE [TableName] = @TableName';
context.log(query);
client.connect();
client.query(query);
await client.end();
context.log('insert completed successfully!');
};
There are other methods to migrate you can look into like using DMS or Export/Import
Hope this helps.
Thank you
Navtej S