Suppressing CONTEXT lines in psql

CONTEXT messages are quite informative, but when you don't need them, they can be real pain in the eyes:

psql:trees.sql:68: NOTICE:  Adding tree structures to table public.testit.
CONTEXT:  SQL function "add_tree_structure" statement 1
psql:trees.sql:68: NOTICE:  Tree table will be public.testit_tree.
CONTEXT:  SQL function "add_tree_structure" statement 1
psql:trees.sql:68: NOTICE:  Primary key in source table is: id
CONTEXT:  SQL function "add_tree_structure" statement 1

I mean – I know the context. I'm writing the sql file right now, how to disable it?

Continue reading Suppressing CONTEXT lines in psql

keyboard shortcuts in psql

there is this quite old, but pretty functional concept: keyboard shortcuts.

you know it – you press ctrl-s, and your editor saves currently-edited file.

my problem is that there are some standard cases when i would really love to have this ability in psql. but psql doesn't support it. or does it?

Continue reading keyboard shortcuts in psql