Question

7
Replies
869
Views
Pavanir6 Member since 2016 103 posts
Amazon
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

How to extract data from Blob in pgsql DB with query

Hi All,

I need to extract how many users do not have ext authentication enabled in operators tables. pyImportedUser is false it means no external authentical.

I wrote a query like below it's not working please help me.

Select pr_read_from_stream('pyImportedUser',pzInsKey,pzpvstream) from DATA.PR_OPERATORS;

SELECT data.pr_read_int_from_stream('pyImportedUser',(SELECT pzpvstream FROM DATA.PR_OPERATORS ) );

***Edited by Moderator Marissa to add SR Details***

Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn