[This topic is migrated from our old forums. The original author name has been removed]
From what I can tell, I can't specify if there should be a line break, or not, for the keyword "ON".
I apologize if this is already a feature and shouldn't be a request. Searching in the forums for the word "ON" is impossible. Probably due to stop words.
A snippet of a sql statement:
mydatabase.public.foo (id) MATCH SIMPLE ON
UPDATE NO ACTION
DELETE NO ACTION
I'd like it to be one line
mydatabase.public.foo (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
This also applies to joins. The formatting is great otherwise.
over 9 years ago
[This reply is migrated from our old forums.]
Re: SQL Formatting the keyword "ON"
You're right, there is no option that matches your requirement. We have adding more formatting options on the list of things to look at in the future. I have added your suggestion and vote.