How to read pzPVStream (BLOB) in PostgreSQL
Function pr_read_from_stream doesn't work with PostgreSql
Is there a way to read BLOB from pgAdmin 4
Coming soon (EOY '25) a brand new Community just for you: Pega Groundbreakers!
To get things started we have implemented Expert Circles on the Pega Community!
Check out our Expert Circles and join the conversation!
This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.
Function pr_read_from_stream doesn't work with PostgreSql
Is there a way to read BLOB from pgAdmin 4
@Krishnachandran Mohan I want to use in sql.
Need to run queries to identify certain data set for analysis and it would be quick to get reports with sql on DB client itself. This is an iterative process (with different criterias each time), hence looking for sql option.
Other way would be to prepare it via Pega.
Please use the below way
pegadata.pr_read_from_stream('"Property Name"', "PC0".pzInsKey, "PC0".pzPVStream)
Thanks,
Krish
@ANKIT_D Using BIX extract data can be retrieved from BLOB irrespective of DB that is used. If its above 8.x pega version PegaBIX comes as part of product itself. Configure the RSV in your application and formulate an extract and execute it manually.
https://docs-previous.pega.com/business-intelligence-exchange-bix/business-intelligence-exchange-bix
Here is how you can retrieve data from a property that is not optimized (i.e. Blob), using SQL.
1. First of all, make sure UDF "pr_read_from_stream" is installed in your database.
2. Run below query. In this example, I am trying to obtain value from "MyBlobProperty" property of a work object whose pzInsKey is "MyCo-MyApp-Work P-1". Transform this SQL to meet your needs in your environment.
select rules.pr_read_from_stream('.MyBlobProperty', pzInsKey, pzPVStream)
from data.pc_myco_myapp_work
where pzinskey = 'MYCO-MYAPP-WORK P-1';
Thanks,
Question
Question Solved
Question
Question
Question
Question
Discussion
Question
Question Solved
Question
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.