supabase/postgres

NULLs don't show clearly on test outputs

Opened this issue · 0 comments

Problem

By default NULLs show as blank on the test outputs, see:

select pgbouncer.get_auth('test_expired_user_password');
get_auth
-------------------------------
(test_expired_user_password,)
(1 row)

This makes the NULL results not obvious at first sight.

Solution

Try adding an option like \pset null '<null>' so results show like:

           get_auth            
-------------------------------
 (test_expired_user_password,<null>)