Category / Section
How to access stored procedures and functions in PostgreSQL?
Published:
In this article, we will discuss how to access stored procedures and functions in PostgreSQL using Bold BI. Although PostgreSQL stored procedures or functions are not supported directly in Bold BI, you can use them via custom query mode.
Procedures
Procedures do not return any data. You can use the syntax CALL procedurename() to call the procedure.
Here's an example of how to update the freight data in sample table using a procedure named 'updatesample'
Create a PostgreSQL data source in Bold BI and switch to code mode.
Provide the query and execute it.
Functions
You can use the syntax Select * from function() to get the function result.
Create PostgreSQL data source in Bold BI and switch to code mode.
Provide the function query and execute it.
Related Links:
PK
