Question
2
Replies
84
Views
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***
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.