Amazon iconAmazonSep 21, 2026

Migrate SQL Server multi-result-set procedures to PostgreSQL

This post presents two PostgreSQL-native alternatives to refcursors, session-scoped temporary tables and JSON aggregation, compares both against a refcursor baseline, and shows how to implement and validate each in.NET and Npgsql.

Migrate SQL Server multi-result-set procedures to PostgreSQL

Share this story

Send the public story page.

Useful takeaways from this story.

This post presents two PostgreSQL-native alternatives to refcursors, session-scoped temporary tables and JSON aggregation, compares both against a refcursor baseline, and shows how to implement and validate...

Building the complete brief

The page is ready to read now. The fuller skim-friendly version will appear here automatically.

The useful part

This post presents two PostgreSQL-native alternatives to refcursors, session-scoped temporary tables and JSON aggregation, compares both against a refcursor baseline, and shows how to implement and validate each in.NET and Npgsql.

Keep reading in the app

Open the app view to save this story, compare related coverage, and continue from the same source.

Open in app