Question

2
Replies
84
Views
Close popover
srikanth veeraneni (srikanthv8893)
Blue Cross and Blue Shield of Minnesota

Blue Cross and Blue Shield of Minnesota
US
srikanthv8893 Member since 2018 16 posts
Blue Cross and Blue Shield of Minnesota
Posted: October 2, 2020
Last activity: October 6, 2020

extract CSV from Postgres Bytea

CSV file is stored in a postgres table bytea column.

 

I tried "select lo_from_bytea(0,csv) from <table name>;" which gave me csv_oid.

And then I tried "\lo_export <csv_oid> <filename>" which fails.

 

How do I extract a csv and use it as a grid source in Pega?

***Edited by Moderator Marissa to update Support Case Details***
Pega Cloud Case Management Reporting Healthcare and Life Sciences Senior System Architect SR Created