Bad format insert values

darold / pgFormatter

A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/

PostgreSQL License

1.66k stars 100 forks source link

Open Cheban1996 opened 10 months ago

Cheban1996 commented 10 months ago

Expected

INSERT INTO account_types(name)
VALUES 
    ('main'),
    ('sub');

But pgformatter make that

INSERT INTO account_types(name)
    VALUES ('main'),
('sub');

zineanteoh commented 1 month ago

+1 this makes pgFormatter pretty much unusable :(

darold commented 1 month ago

Current code format INSERT like that:

INSERT INTO account_types (name)
    VALUES ('main'),
    ('sub'),
    ('foo');