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
UBS
IN
@KrishnaC2208 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.
Aaseya IT Services Pvt Ltd
GB
Please use the below way
pegadata.pr_read_from_stream('"Property Name"', "PC0".pzInsKey, "PC0".pzPVStream)
Thanks,
Krish
Cognitonic Systems Australia
AU
@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.pega.com/business-intelligence-exchange-bix/business-intelligence-exchange-bix
Pegasystems Inc.
JP
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,