Learn how to write your own functions in Postgres with this course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

3/15 Test the logging function

1. The log table

2. Create a logging function

3. Test the logging function

4. The dim_customer table

5. The stg_customer table

6. Implement the ETL process

7. Test the implementation

8. The newsletter table

9. The subscription table

10. Create a function

11. Function overloading

12. Function testing

13. Mailing list function

14. Executing mailing list function

15. Congratulations

Nicely done! The logging function has been created, so it's time to run a quick test and ensure that it works properly.

Invoke the log_message() function with the following arguments:

Parameter	Value
p_process_name	'Ad-hoc query'
p_message_text	'Log Message - Test'
p_level	'info'

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.