Showing Tag: "procedure" (Show all posts)

Top 5 Stored Procedure Performance Tips You Can Use

Posted by jineesh uvantavida on Friday, December 23, 2022, In : Tips & Ideas. 

Top five performance tips for Stored Procedures

In this post, we will dig into some super easy tips that can be used to speed up your stored procedures.

Knowing how to optimize stored procedures is important, so stick around and I’ll show top five stored procedure performance tips you can use today.

Let’s dig into some super easy tips you...


Continue reading ...
 

How to find List of Stored Procedures/ Functions in PostgresSQL Database

Posted by jineesh uvantavida on Wednesday, December 23, 2020,
Finding procedures without schema name

select n.nspname as schema_name, p.proname as specific_name, l.lanname as language, case when l.lanname = 'internal' then p.prosrc else pg_get_functiondef(p.oid) end as definition, pg_get_function_arguments(p.oid) as arguments from pg_proc p left join pg_namespace n on p.pronamespace = n.oid left join pg_language l on p.prolang = l.oid left join pg_type t on t.oid = p.prorettype where n.nspname not in (...
Continue reading ...
 
 

Translate This Page

 


Make a free website with Yola