Closed
Solved
What is the sql query to decode blob in pgadmin
What is the sql query to decode blob in pgadmin and to get value of a property in pzpvstream
Requirement is we want to know value of a property stored in BLOB in pgadmin(rather than in DS)
Accepted Solution
Posted: 6 years ago
EPAM Systems, Inc.
EPAM Systems, Inc.
ES
Hi @Bogga,
I am not sure about pgadmin, as procedure/function won't be available(as per my knowledge, as the sqlj4 script is run for the schema)
Though, you can locate the property name you want to query and build a SQL query like "pr_read_from_stream('.PropName',pzInsKey,pzPVStream) ".
Syntax: select pr_read_from_stream('.PropName',pzInsKey,pzPVStream) from table_name
Hope it helps, though not sure if it works. Anyways, I'll too learn from this post.
Thanks,
Asif