Question
3
Replies
162
Views
Blue Cross and Blue Shield of Minnesota
Blue Cross and Blue Shield of Minnesota
US
Blue Cross and Blue Shield of Minnesota
Posted: October 2, 2020
Last activity: September 7, 2021
Last activity: 7 Sep 2021 16:00 EDT
Solved
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***
Posted: 1 year ago
Blue Cross and Blue Shield of Minnesota
Blue Cross and Blue Shield of Minnesota
US
I tried inserting CSV in postgres text column and queried from pega but pega rips of line feed. It just gives me a string. I used connect SQL to run query.
Posted: 1 year ago
Blue Cross and Blue Shield of Minnesota
Blue Cross and Blue Shield of Minnesota
US
The property I used is type Text.
Accepted Solution
Posted: 1 month ago
MOD
Pegasystems Inc.
US
Upon reviewing the associated Support ticket, I see that you responded that you found the solution: The CSV is displayed on clipboard. Tracer and rep def results page, show a string.