extract CSV from Postgres Bytea

General
, , , ,
1

CSV file is stored in a postgres table bytea column.

I tried “select lo_from_bytea(0,csv) from

;” which gave me csv_oid.

And then I tried “\lo_export <csv_oid> ” which fails.

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

2

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.

3

The property I used is type Text.

4

@srikanthv8893

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.