Formatting WITH expressions IN PostgreSQL

Is there an option to make

WITH new_comps AS (
INSERT INTO tbl_companies (id, name)
SELECT nextval('tbl_companies_id_seq'), 'Company ' || currval('tbl_companies_id_seq')
FROM generate_series(1, 100) num RETURNING id
)

formatted as:

WITH new_comps AS (
INSERT INTO tbl_companies (id, name)
SELECT nextval('tbl_companies_id_seq'), 'Company ' || currval('tbl_companies_id_seq')
FROM generate_series(1, 100) num RETURNING id
)

(i.e. not to indent the SELECT and FROM lines)?

Please sign in to leave a comment.