How do I migrate stored procedures with return status from SQL Server/Sybase to PostgreSQL

While migrating from SQL Server or Sybase database to PostgreSQL, how do you convert a stored procedure with return status and check if procedure call is successful.

Sample example: EXEC @return_status = sample_proc

主题

数据库

标签

微软 SQL 服务器 PostgreSQL 极光 PostgreSQL

语言

English

AWS-User-7906872

已提问 4 年前494 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

已接受的回答

If there is no need for transactional level commit or rollback statements, then you can opt to make it Function in PostgreSQL and Return Status code as per Execution logic. Function in PostgreSQL should suffice most of cases as compared to Procedure in commercial database engines.

Deepak Mahto

已回答 4 年前

How do I migrate stored procedures with return status from SQL Server/Sybase to PostgreSQL

相关内容