pgFormatter icon indicating copy to clipboard operation
pgFormatter copied to clipboard

Formatting Help (Potential Feature Request)

Open isaacsanders opened this issue 2 years ago • 0 comments

Can I use pgFormatter to get this query

SELECT
    username,
    first_name,
    last_name,
    start_of_employment,
    end_of_employment
FROM
    employees
WHERE
    username IN ('tcbgpF46JJ', '5m6PFQ60Gd', 'z7vz3WJH6E', 'S5JPy48rLI', 'bKj3C-z1UI', 'NOEiCNJkQs', 'sz7NM-iBLQ', 'M4iYaA95UA', 'IvKVsadzDR', 'L1C3SGBwrp', 'aOYXq_JEkK', '8hv1.zDxcT', 'WRg8XIM_xJ', 'tdisducrdm', '6xWZqWNVZJ', 'oyxLJwKGlp', 'Tt6dkxMA4i', '4BsM0ux905', 'j8TJIq50fX', 'Bc9Q_eVIK1', 'd0TpJrv-5y')
ORDER BY
    start_of_employment;

To look something like

SELECT
    username,
    first_name,
    last_name,
    start_of_employment,
    end_of_employment
FROM
    employees
WHERE
    username IN (
      'tcbgpF46JJ',
      '5m6PFQ60Gd',
      'z7vz3WJH6E',
      'S5JPy48rLI',
      'bKj3C-z1UI',
      'NOEiCNJkQs',
      'sz7NM-iBLQ',
      'M4iYaA95UA',
      'IvKVsadzDR',
      'L1C3SGBwrp',
      'aOYXq_JEkK',
      '8hv1.zDxcT',
      'WRg8XIM_xJ',
      'tdisducrdm',
      '6xWZqWNVZJ',
      'oyxLJwKGlp',
      'Tt6dkxMA4i',
      '4BsM0ux905',
      'j8TJIq50fX',
      'Bc9Q_eVIK1',
      'd0TpJrv-5y'
    )
ORDER BY
    start_of_employment;

I can't determine if there is a flag I am using inappropriately.

isaacsanders avatar Mar 08 '23 19:03 isaacsanders