Question
Blue Cross and Blue Shield of Minnesota
US
Last activity: 7 Sep 2021 16:00 EDT
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?
Accepted Solution
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.
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.
Accepted Solution
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.