shc_data=> SELECT proname AS function_name,proacl AS privileges FROM pg_proc WHERE proname in ('sql_insert_data_procedure','sql_select_data_procedure','sql_select_size_procedure','sql_update_data_procedure');
function_name | privileges
---------------------------+------------
sql_select_size_procedure |
sql_select_data_procedure |
sql_insert_data_procedure |
sql_update_data_procedure |
(4 rows)
shc_data=> DROP PROCEDURE sql_insert_data_procedure;
ERROR: could not find a procedure named "sql_insert_data_procedure"
shc_data=> SHOW search_path
shc_data->
shc_data-> ^C
shc_data=> SHOW search_path;
search_path
-----------------
"$user", public
(1 row)
shc_data=>
Regards,
Sasmit Utkarsh
+91-7674022625