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.