Retrieve Notice from stored procedure in backend from postgresql

Question

I'm using PostgreSQL with stored functions and PHP with PDO for the system. Is there any way to catch RAISE NOTICE "sometext here" in PHP from the PostgreSQL? It will be really useful to me, if I can catch all notice for debug purpose.

Thank you for the answer/s/ and the time.

Answer 1

Maybe you cant do it directly, but.. As far as it is only for debug purpose, psql notices are captured by handler itself where when notice is issued php updates variable holding it and does not append the value to some array, as Kouber Saparev said in his post: Get all notices of PostgreSQL's RAISE NOTICE

You should better look for some php error handling functions if you need to catch it.